Description
Sending this ticket as placeholder since team already working on the fix.
Following query doesn't work (returns empty result):
SELECT o2.month, c2.address.zip, SUM(o2.sale_price)
FROM `bucket-1` c2 INNER JOIN `bucket-1` o2 ON (META(o2).id IN c2.order_list)
WHERE c2.address.zip = "00040" AND o2.month = "October"
GROUP BY o2.month, c2.address.zip ORDER BY SUM(o2.sale_price)
While query below returns correct result:
SELECT o2.month, c2.address.zip, SUM(o2.sale_price)
FROM `bucket-1` c2 INNER JOIN `bucket-1` o2 ON (META(o2).id IN c2.order_list)
WHERE c2.address.zip = "00040" AND o2.month = "October" AND c2.x IS MISSING
GROUP BY o2.month, c2.address.zip ORDER BY SUM(o2.sale_price)
Attachments
For Gerrit Dashboard: MB-30287 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
96232,2 | MB-30287 ANSI JOIN converted to lookup join does not work properly if covered index scan is used for left-hand side keyspace | master | query | Status: MERGED | +2 | +1 |
96236,2 | MB-30287: Move query and related projects to 'vulcan' branches | master | manifest | Status: MERGED | +2 | +1 |
96239,2 | MB-30287 ANSI JOIN converted to lookup join does not work properly if covered index scan is used for left-hand side keyspace | vulcan | query | Status: MERGED | +2 | +1 |
96351,2 | MB-30287 Check nil pointer | master | query | Status: MERGED | +2 | +1 |
96352,2 | MB-30287 Check nil pointer | vulcan | query | Status: MERGED | +2 | +1 |