Description
Similar to MB-42745, except putting the WHERE clause filter as part of the ON clause:
SELECT *
FROM `travel-sample` r
JOIN `travel-sample` a
ON r.airlineid = META(a).id
AND a.country = "United States"
limit 10
With only primary index defined on the bucket, this query returns country other than "United States" as well.
This issue reproduces in both Cheshire-Cat as well as Mad-Hatter, which is different than MB-42745. It is not a regression. It should also reproduce in 5.5 and 6.0 lines although I've not verified that.
Attachments
Issue Links
- relates to
-
MB-42745 Join on document key returns incorrect results
- Closed
For Gerrit Dashboard: MB-42754 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
140287,2 | MB-42754 Evaluate additional ON-clause filters when joining on document key | master | query | Status: MERGED | +2 | +1 |