Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.0.3
-
Untriaged
-
1
-
Unknown
Description
Steps to reproduce:
a. Create bucket customer, scope s1, and collections c1 and c2.
b. Add this doc in c1 and c2:
{"id": 1} |
c. create these indexes:
CREATE PRIMARY INDEX ON `customer`.`s1`.`c1`;
|
CREATE INDEX `idx1` ON `customer`.`s1`.`c2`(`id`);
|
d. run this query:
SELECT lhs.id
|
FROM customer.s1.c1 lhs
|
LEFT JOIN customer.s1.c2 rhs
|
ON lhs.id = rhs.id
|
AND rhs.x between 1 and 10 |
No documents are output.
e. run this query:
SELECT lhs.id
|
FROM customer.s1.c1 lhs
|
LEFT JOIN customer.s1.c2 rhs
|
ON lhs.id = rhs.id
|
AND rhs.x >= 1 and rhs.x <= 10 |
Now I get 1 doc.
Attachments
Issue Links
For Gerrit Dashboard: MB-51736 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
173308,2 | MB-51736 Properly handle derived filters in post-join filter determination | master | query | Status: MERGED | +2 | +1 |
173310,2 | MB-51736 Modify fix | master | query | Status: MERGED | +2 | +1 |