You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Sean Broeder (Jira)" <ji...@apache.org> on 2021/06/10 18:21:00 UTC

[jira] [Created] (CALCITE-4647) intersect returns wrong results

Sean Broeder created CALCITE-4647:
-------------------------------------

             Summary: intersect returns wrong results
                 Key: CALCITE-4647
                 URL: https://issues.apache.org/jira/browse/CALCITE-4647
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.26.0
            Reporter: Sean Broeder


select n_nationkey from
    (select n_nationkey, n_name from 
        (values (0, 'ALGERIA'), (1, 'ARGENTINA'), (2, 'BRAZIL'), (3, 'CANADA'))
            as nation(n_nationkey, n_name)
    intersect
    select n_nationkey, n_name from 
        (values (2, 'BRAZIL'), (3, 'CANADA'), (4, 'EGYPT'))
            as nation2(n_nationkey, n_name))

should return:
N_NATIONKEY=2
N_NATIONKEY=3

but returns an empty result



--
This message was sent by Atlassian Jira
(v8.3.4#803005)