[jira] [Commented] (CALCITE-3508) Strengthen outer Join to inner if it is under a Filter that discards null values

2019-11-18 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16976345#comment-16976345 ] Julian Hyde commented on CALCITE-3508: -- Regarding what you call "negation filters". I think that

[jira] [Commented] (CALCITE-3508) Strengthen outer Join to inner if it is under a Filter that discards null values

2019-11-17 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16976332#comment-16976332 ] Julian Hyde commented on CALCITE-3508: -- Strengthening the join type seems to be a natural

[jira] [Commented] (CALCITE-3508) Strengthen outer Join to inner if it is under a Filter that discards null values

2019-11-17 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16976218#comment-16976218 ] Danny Chen commented on CALCITE-3508: - Thanks, [~ScottReynolds], either is okey for me, choose the

[jira] [Commented] (CALCITE-3508) Strengthen outer Join to inner if it is under a Filter that discards null values

2019-11-17 Thread Scott Reynolds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16976210#comment-16976210 ] Scott Reynolds commented on CALCITE-3508: - I am left with one more remaining design question.

[jira] [Commented] (CALCITE-3508) Strengthen outer Join to inner if it is under a Filter that discards null values

2019-11-16 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16975860#comment-16975860 ] Danny Chen commented on CALCITE-3508: - Thanks [~ScottReynolds], i think the Strong policy is a

[jira] [Commented] (CALCITE-3508) Strengthen outer Join to inner if it is under a Filter that discards null values

2019-11-16 Thread Scott Reynolds (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16975780#comment-16975780 ] Scott Reynolds commented on CALCITE-3508: - Thank you for the subject change it is considerably

[jira] [Commented] (CALCITE-3508) Strengthen outer Join to inner if it is under a Filter that discards null values

2019-11-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16975599#comment-16975599 ] Danny Chen commented on CALCITE-3508: - I agree with Julian, we may need a method like

[jira] [Commented] (CALCITE-3508) Strengthen outer Join to inner if it is under a Filter that discards null values

2019-11-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16975520#comment-16975520 ] Julian Hyde commented on CALCITE-3508: -- I changed the subject, because "FILTER clause" is an