[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16819265#comment-16819265 ] Vineet Garg commented on CALCITE-2986: -- [~hyuan] Right I was talking about <>ANY in general case. 

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818511#comment-16818511 ] Haisheng Yuan commented on CALCITE-2986: I got it. I thought you are say <>ANY in where clause.

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818502#comment-16818502 ] Vineet Garg commented on CALCITE-2986: -- [~hyuan] Let's say you have {code:sql}select col1, col2 <>

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818490#comment-16818490 ] Haisheng Yuan commented on CALCITE-2986: > Problem with semi join transformation is that it

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818396#comment-16818396 ] Vineet Garg commented on CALCITE-2986: -- bq. I think the <> ANY must be taken into the join

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16817092#comment-16817092 ] Vineet Garg commented on CALCITE-2986: -- bq. It's not true that IN will be rewritten to LEFT join,

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16816817#comment-16816817 ] Danny Chan commented on CALCITE-2986: - >  IN corresponds to = and is rewritten using LEFT OUTER

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16816716#comment-16816716 ] Vineet Garg commented on CALCITE-2986: -- bq  <>ANY should probably be transformed in same way as IN

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16816715#comment-16816715 ] Vineet Garg commented on CALCITE-2986: -- I have opened a pull request for {{=ANY}} rewrite. I still

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16816096#comment-16816096 ] Danny Chan commented on CALCITE-2986: - [~vgarg] Agree with you that the semi join should not only

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812867#comment-16812867 ] Vineet Garg commented on CALCITE-2986: -- [~hyuan] I have given it some thought and as you noticed

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812830#comment-16812830 ] Haisheng Yuan commented on CALCITE-2986: Sorry, I mean <> ALL is equivalent to NOT IN. for <>

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812824#comment-16812824 ] Haisheng Yuan commented on CALCITE-2986: You are right, <> ANY is equivalent to NOT IN. >

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812799#comment-16812799 ] Vineet Garg commented on CALCITE-2986: -- {{=ANY}} is equivalent to IN therefore such queries should