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