[jira] [Created] (IGNITE-25832) Calcite engine. Union of nullable and not nullable types produce wrong data type

[Aleksey Plekhanov (Jira)]

Aleksey Plekhanov created IGNITE-25832:
------------------------------------------

             Summary: Calcite engine. Union of nullable and not nullable types 
produce wrong data type
                 Key: IGNITE-25832
                 URL: https://issues.apache.org/jira/browse/IGNITE-25832
             Project: Ignite
          Issue Type: Bug
            Reporter: Aleksey Plekhanov
            Assignee: Aleksey Plekhanov


Sometimes it's also throws an error. For example:

{code:java}
        sql("CREATE TABLE t(a DATE)");
        sql("SELECT a FROM t UNION ALL SELECT CURRENT_TIMESTAMP");
{code}
Throws:

{noformat}
java.lang.AssertionError: Conversion to relational algebra failed to preserve 
datatypes:
validated type:
RecordType(TIMESTAMP(0) NOT NULL A) NOT NULL
converted type:
RecordType(TIMESTAMP(0) EXPR$0) NOT NULL
{noformat}





--
This message was sent by Atlassian Jira
(v8.20.10#820010)