Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.34.0
Description
Tested CONCAT function in Oracle and got the corresponding results.
select concat('a', cast(null as varchar(20))) from DUAL; --- results in 'a'
select concat('a', null) from DUAL; select 'a' || null from DUAL; --- both result in 'a'
In Calcite(see checkConcat2Func() in SqlOperatorTest.java), CONCAT2 function gets null when running:
concat('a', cast(null as varchar))
Attachments
Issue Links
- is related to
-
CALCITE-815 Add an option to allow empty strings to represent null values
- Open
-
CALCITE-5741 Add CONCAT_WS function (enabled in MSSQL, MySQL, Postgres libraries)
- Closed
- links to