[jira] [Commented] (CALCITE-6176) 'exists' in 'join on' has a wrong result with CoreRules.JOIN_SUB_QUERY_TO_CORRELATE

2024-01-08 Thread Egor Malko (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17804451#comment-17804451 ] Egor Malko commented on CALCITE-6176: - I have done small investigation. It seems like

[jira] [Commented] (CALCITE-6176) 'exists' in 'join on' has a wrong result with CoreRules.JOIN_SUB_QUERY_TO_CORRELATE

2024-01-03 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17802329#comment-17802329 ] Julian Hyde commented on CALCITE-6176: -- This seems to be a bug. I looked at your first query, and