modules/sql-engine/src/integrationTest/sql/group1/cast/test_cast_string.test

# name: test/sql/cast/test_cast_string.test
# description: Test string casts
# group: [cast]
# feature: SQL F201(CAST function)

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

statement error: Cast function cannot convert value of type VARCHAR to type BINARY(1)
SELECT CAST('abc'::VARCHAR AS BINARY)

statement error: Cast function cannot convert value of type VARCHAR to type VARBINARY
SELECT CAST('abc'::VARCHAR AS VARBINARY)

query T
SELECT CAST('c4a0327c-44be-416d-ae90-75c05079789f'::VARCHAR AS UUID)
----
c4a0327c-44be-416d-ae90-75c05079789f