query I
SELECT 1
----
1

statement error
SELECT x

query T
SELECT 'a'
----
a

query B
SELECT 1.01=1.01
----
true

query B
SELECT (0, 1) = (0, 1)
----
true

query B
SELECT (0, 1) != (0, 1)
----
false

query B
SELECT (0, 1, 2) = (0, 1)
----
false

query B
SELECT (0, 1, 2) >= (0, 1)
----
true

query B
SELECT 1::CHAR = 1::VARCHAR
----
true

query B
SELECT 1::CHAR = 2::VARCHAR
----
false

query B
SELECT NULL=NULL
----
null

query B
SELECT NOT(1=1)
----
false

query B
SELECT NOT(1::boolean)
----
false

query B
SELECT TRUE
----
true

query B
SELECT FALSE
----
false

query B
SELECT NOT(TRUE)
----
false

query I
SELECT IF(TRUE, 1, 2)
----
1

query I
SELECT IF(FALSE, 1, 2)
----
2

query I
SELECT IF(NULL, 1, 2)
----
2

query I
SELECT NULLIF(1, 2)
----
1

query I
SELECT NULLIF(NULL, 2)
----
null

query I
SELECT NULLIF(NULL, NULL)
----
null

query I
SELECT IFNULL(1, NULL)
----
1

query I
SELECT IFNULL(NULL, 1)
----
1

query I
SELECT IFNULL(NULL, NULL)
----
null

query I
SELECT COALESCE(1)
----
1

query I
SELECT COALESCE(1, 2, 3)
----
1

query I
SELECT COALESCE(NULL, 2, 3)
----
2

query I
SELECT COALESCE(NULL, 2, NULL)
----
2

query I
SELECT COALESCE(NULL, NULL)
----
null

query I
SELECT COALESCE()
----
null

query I
SELECT CASE 1 WHEN 0 THEN 0 WHEN 1 THEN 1 WHEN NULL THEN 9 ELSE 2 END
----
1

query I
SELECT CASE 3 WHEN 0 THEN 0 WHEN 1 THEN 1 WHEN NULL THEN 9 ELSE 2 END
----
2

query I
SELECT CASE 3 WHEN 0 THEN 0 WHEN 1 THEN 1 WHEN NULL THEN 9 END
----
null

query I
SELECT CASE 3 WHEN 0 THEN 0 WHEN 1 THEN 1 WHEN NULL THEN 9 ELSE 2 END
----
2

query I
SELECT CASE WHEN TRUE THEN 0 WHEN FALSE THEN 1 WHEN FALSE THEN 9 ELSE 2 END
----
0

query I
SELECT CASE WHEN FALSE THEN 0 WHEN FALSE THEN 1 WHEN FALSE THEN 9 ELSE 2 END
----
2

query I
SELECT CASE WHEN FALSE THEN 0 WHEN FALSE THEN 1 WHEN FALSE THEN 9 END
----
null

query I
SELECT CASE WHEN FALSE THEN 0 WHEN 1=1 THEN 1 WHEN FALSE THEN 9 ELSE 2 END
----
1

# issue: https://github.com/sqlparser-rs/sqlparser-rs/issues/362
# query T
# SELECT 'That\'s good.'
# ----
# That's good.

statement error
SELECT *