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)