[ https://issues.apache.org/jira/browse/CALCITE-5214?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated CALCITE-5214: ------------------------------------ Labels: pull-request-available (was: ) > Implicit type conversion fails in union sql > ------------------------------------------- > > Key: CALCITE-5214 > URL: https://issues.apache.org/jira/browse/CALCITE-5214 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.30.0 > Reporter: Hailin Wang > Priority: Major > Labels: pull-request-available > Time Spent: 10m > Remaining Estimate: 0h > > > The following test: > {code:java} > // > org.apache.calcite.test.SqlToRelConverterTest#testUnionNullableImplicitTypeCoercion > @Test void testUnionNullableImplicitTypeCoercion() { > final String sql = > "select id from (values(1), (null)) t (id) union select 'varchar-id' as > id"; > sql(sql).ok(); > } {code} > Fails with the following exception: > {code:java} > Exception in thread "main" java.lang.AssertionError: Conversion to relational > algebra failed to preserve datatypes: > validated type: > RecordType(VARCHAR NOT NULL ID) NOT NULL > converted type: > RecordType(VARCHAR EXPR$0) NOT NULL > rel: > LogicalUnion(all=[false]) > LogicalProject(EXPR$0=[CAST($0):VARCHAR]) > LogicalValues(tuples=[[{ 1 }, { null }]]) > LogicalValues(tuples=[[{ 'varchar-id' }]]) at > org.apache.calcite.sql2rel.SqlToRelConverter.checkConvertedType(SqlToRelConverter.java:486) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:601) > at org.apache.calcite.prepare.PlannerImpl.rel(PlannerImpl.java:259) {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)