Details
-
Bug
-
Resolution: Fixed
-
Critical
-
Cheshire-Cat
-
Untriaged
-
1
-
Yes
Description
SELECT *
FROM `travel-sample` r
JOIN `travel-sample` a
ON r.airlineid = META(a).id
WHERE a.country = "United States"
limit 10
The above query result includes airlines from country other than United States. Only primary on bucket is used in the plan.
Build: Enterprise Edition 7.0.0 build 3613
Not reproducible in Enterprise Edition 6.6.0 build 7909
Attachments
Issue Links
- relates to
-
MB-42754 Join on document key and extra filter in the ON-clause may return incorrect result
-
- Closed
-
For Gerrit Dashboard: MB-42745 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
140266,2 | MB-42745 Save/restore filter for consideration of different join methods | master | query | Status: MERGED | +2 | +1 |