[jira] [Commented] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-07 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16678573#comment-16678573 ] Julian Hyde commented on CALCITE-2659: -- The plan produces the correct result. Howe

[jira] [Commented] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-07 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16678837#comment-16678837 ] Haisheng Yuan commented on CALCITE-2659: Here is a simpler test case with exist

[jira] [Commented] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-07 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16678856#comment-16678856 ] Haisheng Yuan commented on CALCITE-2659: The plan produces correct result in th

[jira] [Commented] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-08 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16679092#comment-16679092 ] Julian Hyde commented on CALCITE-2659: -- We need the COALESCE because proving that

[jira] [Commented] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-08 Thread Yuzhao Chen (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16680732#comment-16680732 ] Yuzhao Chen commented on CALCITE-2659: -- [~julianhyde] I can help to fix this, kin

[jira] [Commented] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-09 Thread yuqi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16681553#comment-16681553 ] yuqi commented on CALCITE-2659: --- [~julianhyde], i could not understand your answer 'The p

[jira] [Commented] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-09 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16681581#comment-16681581 ] Haisheng Yuan commented on CALCITE-2659: As I mentioned, for left outer join, i

[jira] [Commented] (CALCITE-2659) Wrong plan In natural left/right join

2018-11-09 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16681823#comment-16681823 ] Julian Hyde commented on CALCITE-2659: -- I'm glad we're agreed that the plan with C