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)