[
https://issues.apache.org/jira/browse/CALCITE-7932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-7932:
------------------------------------
Labels: pull-request-available (was: )
> INTERSECT causes a validator crash
> ----------------------------------
>
> Key: CALCITE-7932
> URL: https://issues.apache.org/jira/browse/CALCITE-7932
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.42.0
> Reporter: Mihai Budiu
> Priority: Minor
> Labels: pull-request-available
>
> The following program crashes the validator:
> {code:java}
> select x from (values (1)) as t(x)
> intersect
> select x from (values (1), (cast(null as integer))) as t(x)
> intersect
> select x from (values (cast(1 as bigint)), (cast(null as bigint))) as t(x);
> {code}
> The error is:
> {code:java}
> java.lang.AssertionError: Conversion to relational algebra failed to preserve
> datatypes:
> validated type:
> RecordType(BIGINT X) NOT NULL
> converted type:
> RecordType(BIGINT NOT NULL X) NOT NULL{code}
> I believe this was introduced in CALCITE-6451 [~jensen]
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
