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

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

[jira] [Created] (CALCITE-4648) Except returns wrong results

Sean Broeder created CALCITE-4648:
-------------------------------------

             Summary: Except returns wrong results
                 Key: CALCITE-4648
                 URL: https://issues.apache.org/jira/browse/CALCITE-4648
             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)
    except
    select n_nationkey, n_name from 
        (values (2, 'BRAZIL'), (3, 'CANADA'), (4, 'EGYPT'))
            as nation2(n_nationkey, n_name))

should return 
N_NATIONKEY=0
N_NATIONKEY=1

but returns 
N_NATIONKEY=0
N_NATIONKEY=1
N_NATIONKEY=2
N_NATIONKEY=3



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