You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (Jira)" <ji...@apache.org> on 2021/06/12 20:37:00 UTC
[jira] [Resolved] (CALCITE-4648) Except returns wrong results
[ https://issues.apache.org/jira/browse/CALCITE-4648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde resolved CALCITE-4648.
----------------------------------
Resolution: Duplicate
Like CALCITE-4647, this is a duplicate of CALCITE-4590.
> 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
> Priority: Major
>
> 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)