[jira] [Created] (CALCITE-5745) CONCAT2 function(enabled in Oracle library) gets wrong result when one of the argument is NULL

Fri, 02 Jun 2023 08:10:07 -0700 

ZheHu created CALCITE-5745:
------------------------------

             Summary: CONCAT2 function(enabled in Oracle library) gets wrong 
result when one of the argument is NULL
                 Key: CALCITE-5745
                 URL: https://issues.apache.org/jira/browse/CALCITE-5745
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.34.0
            Reporter: ZheHu
            Assignee: ZheHu


Tested CONCAT function in Oracle and got the corresponding results.
{code}
select concat('a', cast(null as varchar(20))) from DUAL;
--- results in 'a'
{code}

{code}
select concat('a', null) from DUAL;
select 'a' ||  null from DUAL;
--- both result in 'a'
{code}

In Calcite(see checkConcat2Func() in SqlOperatorTest.java), CONCAT2 function 
gets null when running:
{code}
concat('a', cast(null as varchar))
{code}



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

Reply via email to