Mihai Budiu created CALCITE-7932:
------------------------------------
Summary: 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
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)
