Konstantin Orlov created IGNITE-17131:
-----------------------------------------
Summary: Wrong result if subquery is the left child of LEFT JOIN
operator
Key: IGNITE-17131
URL: https://issues.apache.org/jira/browse/IGNITE-17131
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 2.13
Reporter: Konstantin Orlov
Assignee: Konstantin Orlov
Currently a query with a filtering subquery of a left side of a LEFT JOIN
returns an invalid result. Looks like the problem is somewhere inside
{{{}GridSubqueryJoinOptimizer{}}}.
The possible workaround is to turn the join rewriting off by setting the system
property {{IGNITE_ENABLE_SUBQUERY_REWRITE_OPTIMIZATION}} to false.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
