[
https://issues.apache.org/jira/browse/CALCITE-4647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17361323#comment-17361323
]
duan xiong commented on CALCITE-4647:
-------------------------------------
Hi，[~julianhyde] [~sbroeder] I have test this issue. It is same problem as
CALCITE-4590. So I releated this to 4590. If we set
shouldConvertRaggedUnionTypesToVarying is true. This can return the right
result. But this is still a bug.
> 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
> 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)
> 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)
