[jira] [Commented] (CALCITE-5743) An error occurs when count appears in the correlated subquery select list

2023-06-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729783#comment-17729783 ] Julian Hyde commented on CALCITE-5743: -- Rather than adding a join, could the exist

[jira] [Commented] (CALCITE-5743) An error occurs when count appears in the correlated subquery select list

2023-06-06 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729691#comment-17729691 ] libopeng commented on CALCITE-5743: ---   {code:java} LogicalProject(A=[$0])   LogicalJo

[jira] [Commented] (CALCITE-5743) An error occurs when count appears in the correlated subquery select list

2023-06-02 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728792#comment-17728792 ] Julian Hyde commented on CALCITE-5743: -- I believe that decorrelation is converting