[
https://issues.apache.org/jira/browse/CALCITE-4258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ruben Q L updated CALCITE-4258:
-------------------------------
Description:
Problem can be reproduced with the following tests (in
core\src\test\resources\sql\misc.iq):
{code}
# [CALCITE-4258]
SELECT 1 IS DISTINCT FROM NULL;
+--------+
| EXPR$0 |
+--------+
| true |
+--------+
(1 row)
!ok
# [CALCITE-4258]
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}
These queries used to work fine until recently, so this regression must have
occurred not so long ago.
was:
Problem can be reproduced with the following tests (in
core\src\test\resources\sql\misc.iq):
{code}
# [CALCITE-4258]
SELECT 1 IS DISTINCT FROM NULL;
+--------+
| EXPR$0 |
+--------+
| true |
+--------+
(1 row)
!ok
# [CALCITE-4258]
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}
These queries used to work fine until recently, so this regression must have
occurred not so long ago.
> 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
> Priority: Major
>
> Problem can be reproduced with the following tests (in
> core\src\test\resources\sql\misc.iq):
> {code}
> # [CALCITE-4258]
> SELECT 1 IS DISTINCT FROM NULL;
> +--------+
> | EXPR$0 |
> +--------+
> | true |
> +--------+
> (1 row)
> !ok
> # [CALCITE-4258]
> 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}
> These queries used to work fine until recently, so this regression must have
> occurred not so long ago.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
