blob: bfa29d7d2d597658f2ffc442ed1399db1615c135 (
plain) (
tree)
|
|
-- Automatically generated by SQLQueryTestSuite
-- Number of queries: 22
-- !query 0
SELECT CAST('1.23' AS int)
-- !query 0 schema
struct<CAST(1.23 AS INT):int>
-- !query 0 output
1
-- !query 1
SELECT CAST('1.23' AS long)
-- !query 1 schema
struct<CAST(1.23 AS BIGINT):bigint>
-- !query 1 output
1
-- !query 2
SELECT CAST('-4.56' AS int)
-- !query 2 schema
struct<CAST(-4.56 AS INT):int>
-- !query 2 output
-4
-- !query 3
SELECT CAST('-4.56' AS long)
-- !query 3 schema
struct<CAST(-4.56 AS BIGINT):bigint>
-- !query 3 output
-4
-- !query 4
SELECT CAST('abc' AS int)
-- !query 4 schema
struct<CAST(abc AS INT):int>
-- !query 4 output
NULL
-- !query 5
SELECT CAST('abc' AS long)
-- !query 5 schema
struct<CAST(abc AS BIGINT):bigint>
-- !query 5 output
NULL
-- !query 6
SELECT CAST('1234567890123' AS int)
-- !query 6 schema
struct<CAST(1234567890123 AS INT):int>
-- !query 6 output
NULL
-- !query 7
SELECT CAST('12345678901234567890123' AS long)
-- !query 7 schema
struct<CAST(12345678901234567890123 AS BIGINT):bigint>
-- !query 7 output
NULL
-- !query 8
SELECT CAST('' AS int)
-- !query 8 schema
struct<CAST( AS INT):int>
-- !query 8 output
NULL
-- !query 9
SELECT CAST('' AS long)
-- !query 9 schema
struct<CAST( AS BIGINT):bigint>
-- !query 9 output
NULL
-- !query 10
SELECT CAST(NULL AS int)
-- !query 10 schema
struct<CAST(NULL AS INT):int>
-- !query 10 output
NULL
-- !query 11
SELECT CAST(NULL AS long)
-- !query 11 schema
struct<CAST(NULL AS BIGINT):bigint>
-- !query 11 output
NULL
-- !query 12
SELECT CAST('123.a' AS int)
-- !query 12 schema
struct<CAST(123.a AS INT):int>
-- !query 12 output
NULL
-- !query 13
SELECT CAST('123.a' AS long)
-- !query 13 schema
struct<CAST(123.a AS BIGINT):bigint>
-- !query 13 output
NULL
-- !query 14
SELECT CAST('-2147483648' AS int)
-- !query 14 schema
struct<CAST(-2147483648 AS INT):int>
-- !query 14 output
-2147483648
-- !query 15
SELECT CAST('-2147483649' AS int)
-- !query 15 schema
struct<CAST(-2147483649 AS INT):int>
-- !query 15 output
NULL
-- !query 16
SELECT CAST('2147483647' AS int)
-- !query 16 schema
struct<CAST(2147483647 AS INT):int>
-- !query 16 output
2147483647
-- !query 17
SELECT CAST('2147483648' AS int)
-- !query 17 schema
struct<CAST(2147483648 AS INT):int>
-- !query 17 output
NULL
-- !query 18
SELECT CAST('-9223372036854775808' AS long)
-- !query 18 schema
struct<CAST(-9223372036854775808 AS BIGINT):bigint>
-- !query 18 output
-9223372036854775808
-- !query 19
SELECT CAST('-9223372036854775809' AS long)
-- !query 19 schema
struct<CAST(-9223372036854775809 AS BIGINT):bigint>
-- !query 19 output
NULL
-- !query 20
SELECT CAST('9223372036854775807' AS long)
-- !query 20 schema
struct<CAST(9223372036854775807 AS BIGINT):bigint>
-- !query 20 output
9223372036854775807
-- !query 21
SELECT CAST('9223372036854775808' AS long)
-- !query 21 schema
struct<CAST(9223372036854775808 AS BIGINT):bigint>
-- !query 21 output
NULL
|
