[jira] [Commented] (CALCITE-3890) Derive IS NOT NULL filter for the inputs of inner join

2022-07-26 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17571209#comment-17571209 ] Chunwei Lei commented on CALCITE-3890: -- Thank you for your attention, [~zabetak]. IMHO, the most

[jira] [Commented] (CALCITE-3890) Derive IS NOT NULL filter for the inputs of inner join

2022-07-25 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17570946#comment-17570946 ] Stamatis Zampetakis commented on CALCITE-3890: -- Hey [~Chunwei Lei] , I didn't notice that

[jira] [Commented] (CALCITE-3890) Derive IS NOT NULL filter for the inputs of inner join

2022-05-11 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17535815#comment-17535815 ] Chunwei Lei commented on CALCITE-3890: -- Exactly. I think {{Strong}} can handle it well. > Derive

[jira] [Commented] (CALCITE-3890) Derive IS NOT NULL filter for the inputs of inner join

2022-05-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17534672#comment-17534672 ] Julian Hyde commented on CALCITE-3890: -- In the particular case of {{IS NOT DISTINCT FROM}} it is

[jira] [Commented] (CALCITE-3890) Derive IS NOT NULL filter for the inputs of inner join

2022-05-10 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17534652#comment-17534652 ] Chunwei Lei commented on CALCITE-3890: -- I am trying to use {{Strong}} to analyze the join

[jira] [Commented] (CALCITE-3890) Derive IS NOT NULL filter for the inputs of inner join

2022-05-10 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17534644#comment-17534644 ] Xurenhe commented on CALCITE-3890: -- I left some doubts in the pr. I am curious about how to analyze

[jira] [Commented] (CALCITE-3890) Derive IS NOT NULL filter for the inputs of inner join

2022-05-10 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17534637#comment-17534637 ] Chunwei Lei commented on CALCITE-3890: -- {quote}The description does not say that the filter is a

[jira] [Commented] (CALCITE-3890) Derive IS NOT NULL filter for the inputs of inner join

2022-05-10 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17534632#comment-17534632 ] Chunwei Lei commented on CALCITE-3890: -- {quote}Emp e LEFT JOIN Dept d USING (deptno) becomes