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

# name: test/sql/cast/test_boolean_cast.test
# description: Test boolean casts
# group: [cast]
# Ignored with https://issues.apache.org/jira/browse/IGNITE-15559

statement ok
PRAGMA enable_verification

query T
SELECT CAST(1=1 AS VARCHAR)
----
TRUE

query T
SELECT CAST(1=0 AS VARCHAR)
----
FALSE

query T
SELECT CAST('true' AS BOOLEAN)
----
true

query T
SELECT CAST('TRUE' AS BOOLEAN)
----
true

query T
SELECT CAST('false' AS BOOLEAN)
----
false

query T
SELECT CAST('FALSE' AS BOOLEAN)
----
false

statement error
SELECT CAST('12345' AS BOOLEAN)

query T
SELECT CAST(CAST('12345' AS INTEGER) AS BOOLEAN)
----
true

query T
SELECT CAST(CAST('0' AS INTEGER) AS BOOLEAN)
----
false

query T
SELECT CAST(CAST('1' AS tinyint) AS BOOLEAN)
----
true

query T
SELECT CAST(CAST('0' AS tinyint) AS BOOLEAN)
----
false

query T
SELECT CAST(CAST('1' AS smallint) AS BOOLEAN)
----
true

query T
SELECT CAST(CAST('0' AS smallint) AS BOOLEAN)
----
false

query T
SELECT CAST(CAST('1' AS integer) AS BOOLEAN)
----
true

query T
SELECT CAST(CAST('0' AS integer) AS BOOLEAN)
----
false

query T
SELECT CAST(CAST('1' AS bigint) AS BOOLEAN)
----
true

query T
SELECT CAST(CAST('0' AS bigint) AS BOOLEAN)
----
false

query T
SELECT CAST(CAST('1' AS decimal) AS BOOLEAN)
----
true

query T
SELECT CAST(CAST('0' AS decimal) AS BOOLEAN)
----
false

query T
SELECT CAST(CAST('1' AS decimal(1,0)) AS BOOLEAN)
----
true

query T
SELECT CAST(CAST('0' AS decimal(1,0)) AS BOOLEAN)
----
false

query T
SELECT CAST(CAST('1' AS decimal(9,0)) AS BOOLEAN)
----
true

query T
SELECT CAST(CAST('0' AS decimal(9,0)) AS BOOLEAN)
----
false

query T
SELECT CAST(CAST('1' AS decimal(38,0)) AS BOOLEAN)
----
true

query T
SELECT CAST(CAST('0' AS decimal(38,0)) AS BOOLEAN)
----
false

query T
SELECT CAST(CAST('1' AS float) AS BOOLEAN)
----
true

query T
SELECT CAST(CAST('0' AS float) AS BOOLEAN)
----
false

query T
SELECT CAST(CAST('1' AS double) AS BOOLEAN)
----
true

query T
SELECT CAST(CAST('0' AS double) AS BOOLEAN)
----
false