Aleksey Plekhanov created IGNITE-25830:
------------------------------------------

             Summary: Calcite engine. Double coalesce with null literal throws 
an exception
                 Key: IGNITE-25830
                 URL: https://issues.apache.org/jira/browse/IGNITE-25830
             Project: Ignite
          Issue Type: Bug
            Reporter: Aleksey Plekhanov


Quries like:
{code:java}
SELECT COALESCE(COALESCE(null, 'a'), 'b')
{code}
Fail with:
{noformat}
java.lang.AssertionError: Conversion to relational algebra failed to preserve 
datatypes:
validated type:
RecordType(VARCHAR(1024) CHARACTER SET "UTF-8" NOT NULL EXPR$0) NOT NULL
converted type:
RecordType(CHAR(1) CHARACTER SET "UTF-8" NOT NULL EXPR$0) NOT NULL
{noformat}





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

Reply via email to