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)
