[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17081981#comment-17081981 ] Feng Zhu commented on CALCITE-3893: --- Ok, thanks for your feedback. I'd like to make a

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17080789#comment-17080789 ] Julian Hyde commented on CALCITE-3893: -- bq. But if we allow this pattern, we need

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17080233#comment-17080233 ] Feng Zhu commented on CALCITE-3893: --- {quote}If someone can back up the "a bit hard to

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17079572#comment-17079572 ] Julian Hyde commented on CALCITE-3893: -- By the way, there should be a rule that co

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17079570#comment-17079570 ] Julian Hyde commented on CALCITE-3893: -- If someone can back up the "a bit hard to

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17079075#comment-17079075 ] Vladimir Sitnikov commented on CALCITE-3893: In other words, I would consid

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17079072#comment-17079072 ] Vladimir Sitnikov commented on CALCITE-3893: [~julianhyde], as far as I und

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17079060#comment-17079060 ] Julian Hyde commented on CALCITE-3893: -- I am not convinced that the current behavi

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17074213#comment-17074213 ] Feng Zhu commented on CALCITE-3893: --- The result is correct. It seems that the rutime

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17074015#comment-17074015 ] Julian Hyde commented on CALCITE-3893: -- I removed fixVersion because this is curre

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17074011#comment-17074011 ] Julian Hyde commented on CALCITE-3893: -- Does the query produce the wrong results?

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17073656#comment-17073656 ] Feng Zhu commented on CALCITE-3893: --- [~icshuo], according to the discussion, we will

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17073628#comment-17073628 ] Shuo Cheng commented on CALCITE-3893: - Hi, [~donnyzone], I'm not quite understandin

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17073547#comment-17073547 ] Feng Zhu commented on CALCITE-3893: --- Hi, [~icshuo], thanks for reporting the problem,

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17073506#comment-17073506 ] Shuo Cheng commented on CALCITE-3893: - The plan I suggested may not be rigorous eno

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17073498#comment-17073498 ] Shuo Cheng commented on CALCITE-3893: - Or like this: > SQL with GROUP_ID may gener

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17073493#comment-17073493 ] Vladimir Sitnikov commented on CALCITE-3893: {quote}Maybe that we want is:{