Ruben Q L created CALCITE-4258: ---------------------------------- Summary: SqlToRelConverter: SELECT 1 IS [NOT] DISTINCT FROM NULL fails with AssertionError Key: CALCITE-4258 URL: https://issues.apache.org/jira/browse/CALCITE-4258 Project: Calcite Issue Type: Bug Components: core Reporter: Ruben Q L
Problem can be reproduced with the following tests (in core\src\test\resources\sql\misc.iq): {code} # SELECT 1 IS DISTINCT FROM NULL; +--------+ | EXPR$0 | +--------+ | true | +--------+ (1 row) !ok # SELECT 1 IS NOT DISTINCT FROM NULL; +--------+ | EXPR$0 | +--------+ | false | +--------+ (1 row) !ok {code} These tests fail with: {code} > java.lang.AssertionError: Conversion to relational algebra failed to preserve > datatypes: > validated type: > RecordType(BOOLEAN NOT NULL EXPR$0) NOT NULL > converted type: > RecordType(BOOLEAN EXPR$0) NOT NULL > rel: > LogicalProject(EXPR$0=[null:BOOLEAN]) > LogicalValues(tuples=[[{ 0 }]]) 44a47,109 > at > org.apache.calcite.sql2rel.SqlToRelConverter.checkConvertedType(SqlToRelConverter.java:466) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:581) > at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:242) > at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:208) ... {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)