[jira] [Commented] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17755987#comment-17755987 ] LakeShen commented on CALCITE-5889: --- Hi [~nobigo] ,thank you so much for reviewing my pr. > Add the

[jira] [Commented] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17755942#comment-17755942 ] xiong duan commented on CALCITE-5889: - Hi [~shenlang], This issue is very interesting. I will

[jira] [Commented] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754442#comment-17754442 ] LakeShen commented on CALCITE-5889: --- The PR is

[jira] [Commented] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17752168#comment-17752168 ] Julian Hyde commented on CALCITE-5889: -- You're right. For regular EXCEPT the condition is "c0 > 0

[jira] [Commented] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17751347#comment-17751347 ] LakeShen commented on CALCITE-5889: --- Hi [~julianhyde] ,I get your point,thanks for your advice. >

[jira] [Commented] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750931#comment-17750931 ] LakeShen commented on CALCITE-5889: --- Hi [~julianhyde] ,thanks for you reply. I have a few questions

[jira] [Commented] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750885#comment-17750885 ] Julian Hyde commented on CALCITE-5889: -- Thanks, [~shenlang]. That makes sense. It generalizes

[jira] [Commented] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750626#comment-17750626 ] LakeShen commented on CALCITE-5889: --- Hi [~jhyde] ,the sql like this : {code:java} select e.deptno

[jira] [Commented] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750373#comment-17750373 ] Julian Hyde commented on CALCITE-5889: -- Can you give a SQL query (involving say Emp and Dept) that