LEFT side is covered ANSI JOIN to LOOKUP JOIN transformation doesn't work

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)