zstan commented on PR #13502:
URL: https://github.com/apache/ignite/pull/13502#issuecomment-5354304675
Why it matters only for LEFT OUTER JOIN + WHERE(right)
- Non-LEFT-JOIN queries (majority): same plan, O(#joins) scan adds
~nanoseconds. No impact.
- LEFT JOIN + WHERE on left table: still pushed down. No change.
- LEFT JOIN + WHERE on right table: condition stays in outer wrap query
(post-join filter) instead of pushed into subquery (index range scan).
This shape was buggy before — master's "fast" plan returned wrong
rows (kept NULL-extended rows). So slower than master = correct behavior with
perf cost of the fix.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
