modules/calcite/src/test/sql/cast/test_string_cast.test

# name: test/sql/cast/test_string_cast.test
# description: Test string casts
# group: [cast]

statement ok
PRAGMA enable_verification

query TTT
SELECT (1=1)::VARCHAR, (1=0)::VARCHAR, NULL::BOOLEAN::VARCHAR
----
TRUE
FALSE
null

query TTT
SELECT 1::TINYINT::VARCHAR, 12::TINYINT::VARCHAR, (-125)::TINYINT::VARCHAR
----
1
12
-125

query TTT
SELECT 1::SMALLINT::VARCHAR, 12442::SMALLINT::VARCHAR, (-32153)::SMALLINT::VARCHAR
----
1
12442
-32153

query TTT
SELECT 1::INTEGER::VARCHAR, 12442952::INTEGER::VARCHAR, (-2000000111)::INTEGER::VARCHAR
----
1
12442952
-2000000111

query TTT
SELECT 1::BIGINT::VARCHAR, 1244295295289253::BIGINT::VARCHAR, (-2000000111551166)::BIGINT::VARCHAR
----
1
1244295295289253
-2000000111551166

query TTT
SELECT 2::FLOAT::VARCHAR, 0.5::FLOAT::VARCHAR, (-128.5)::FLOAT::VARCHAR
----
2.0
0.5
-128.5

query TTT
SELECT 2::DOUBLE::VARCHAR, 0.5::DOUBLE::VARCHAR, (-128.5)::DOUBLE::VARCHAR
----
2.0
0.5
-128.5