iwanttobepowerful commented on code in PR #4654: URL: https://github.com/apache/calcite/pull/4654#discussion_r2572734219
########## core/src/test/resources/sql/sub-query.iq: ########## @@ -5443,4 +5443,42 @@ ORDER BY deptno; !ok +# [CALCITE-7303] Subqueries cannot be decorrelated if filter condition have multi CorrelationId Review Comment: yes. I believe there is a bug in Calcite somewhere, which is triggered when a mix of temporary and non-temporary tables is used in the SQL statement. However, there are no issues if only temporary tables or only non-temporary tables are involved. I don’t think this is related to my PR. I’ve added new test cases. -- 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]
