subject:"\[jira\] \[Commented\] \(CALCITE\-5617\) count\(\) \+ left join execution efficiency optimize"

[jira] [Commented] (CALCITE-5617) count() + left join execution efficiency optimize

2023-05-24 Thread hufukang (Jira)

[ https://issues.apache.org/jira/browse/CALCITE-5617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726052#comment-17726052 ] hufukang commented on CALCITE-5617: --- select count(0) as total from (select m.USER_CODE, m.USER_NAME

[jira] [Commented] (CALCITE-5617) count() + left join execution efficiency optimize

2023-05-24 Thread Runkang He (Jira)

[ https://issues.apache.org/jira/browse/CALCITE-5617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726010#comment-17726010 ] Runkang He commented on CALCITE-5617: - [~huge] could you give a SQL example to describe this issue?