modules/sql-engine/src/integrationTest/sql/group1/function/string/test_ascii.test

# name: test/sql/function/string/test_ascii.test
# description:  test ascii() and chr() functions
# group: [string]

# Some ascii checks
query I
SELECT ascii('')
----
0

query I
SELECT ascii('x')
----
120

query I
SELECT ASCII('a')
----
97

query I
SELECT ASCII('ABC')
----
65

query I
SELECT ASCII('Ω')
----
937

query I
SELECT ASCII('ΩΩ')
----
937

query I
SELECT ASCII('Ä')
----
196

statement error: Cannot apply 'ASCII' to arguments of type 'ASCII(<INTEGER>)'
SELECT ASCII(5)

query I
SELECT ASCII(NULL)
----
NULL

statement error: Invalid number of arguments to function 'ASCII'
SELECT ASCII()

query T
SELECT CHR(97)
----
a

query T
SELECT CHR(196)
----
Ä

query T
SELECT CHR(937)
----
Ω

query T
SELECT CHR(NULL)
----
NULL

statement error
SELECT CHR(-10)

statement error
SELECT CHR()