modules/calcite/src/test/sql/function/string/test_concat_function.test

# name: test/sql/function/string/test_concat_function.test
# description: CONCAT test
# group: [string]

statement ok
CREATE TABLE strings(a VARCHAR, b VARCHAR)

statement ok
INSERT INTO strings VALUES ('Hello', 'World'), ('HuLlD', NULL), ('MotörHead','RÄcks')

query T
select CONCAT(a, 'SUFFIX') FROM strings ORDER BY a
----
HelloSUFFIX
HuLlDSUFFIX
MotörHeadSUFFIX

query T
select CONCAT('PREFIX', b) FROM strings ORDER BY a
----
PREFIXWorld
NULL
PREFIXRÄcks

query T
select CONCAT(a, b) FROM strings ORDER BY a
----
HelloWorld
NULL
MotörHeadRÄcks


query T
select CONCAT(a, b, 'SUFFIX') FROM strings ORDER BY a
----
HelloWorldSUFFIX
NULL
MotörHeadRÄcksSUFFIX

query T
select CONCAT(a, b, a) FROM strings ORDER BY a
----
HelloWorldHello
NULL
MotörHeadRÄcksMotörHead

query T
select CONCAT('1', '2', '3', '4', '5', '6', '7', '8', '9', '0')
----
1234567890

# concat a long string
query TT
select '1234567890' || '1234567890', '1234567890' || NULL
----
12345678901234567890	NULL

query TT
select CONCAT('1234567890', '1234567890'), CONCAT('1234567890', NULL)
----
12345678901234567890	NULL