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

# name: test/sql/function/string/test_reverse.test
# description: REVERSE test
# group: [string]

# test reverse on scalars
query TTTT
select REVERSE(''), REVERSE('Hello'), REVERSE('MotörHead'), REVERSE(NULL)
----
(empty)	olleH	daeHrötoM	NULL

# test reverse on tables
statement ok
CREATE TABLE strings(id INTEGER, a VARCHAR, b VARCHAR)

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

query T
select REVERSE(a) FROM strings ORDER BY id
----
olleH
DlLuH
daeHrötoM
(empty)

query T
select REVERSE(b) FROM strings ORDER BY id
----
dlroW
NULL
skcÄR
NULL

query T
select REVERSE(a) FROM strings WHERE b IS NOT NULL ORDER BY id
----
olleH
daeHrötoM

# test incorrect usage of reverse
statement error
select REVERSE()

statement error
select REVERSE(1, 2)

statement error
select REVERSE('hello', 'world')