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

# name: test/sql/cast/test_cast_float.test
# description: CAST FLOAT
# feature: SQL F201(CAST function)
# group: [cast]

statement ok
SELECT CAST('100.0' AS FLOAT);

query T
SELECT CAST('100' AS FLOAT);
----
100.0

# overflow
statement error: REAL out of range
SELECT CAST(1e39 AS FLOAT);

# overflow
statement error: REAL out of range
SELECT CAST(-1e39 AS FLOAT);

query T
SELECT CAST(1e1 AS REAL);
----
10

query I
SELECT CAST('1e1' AS FLOAT);
----
10.0

query I
SELECT CAST('   1e1' AS FLOAT);
----
10.0

for val in [100::TINYINT, 100::SMALLINT, 100::INT, 100::BIGINT, 100::DECIMAL, 100::DECIMAL(3)]

query T
SELECT CAST(${val} AS FLOAT);
----
100

endfor

query T
SELECT CAST(100.1::DECIMAL(4, 1) AS FLOAT);
----
100.1

query T
SELECT CAST(100.1::REAL AS FLOAT);
----
100.1

statement error: For input string: "100x"
SELECT CAST('100x' AS FLOAT);

statement error: Cast function cannot convert value of type BINARY(1) to type FLOAT
SELECT CAST(x'00' AS FLOAT);

statement error: Cast function cannot convert value of type DATE to type FLOAT
SELECT CAST('2000-01-01'::DATE AS FLOAT);

statement error: Cast function cannot convert value of type TIME(0) to type FLOAT
SELECT CAST('00:00:00'::TIME AS FLOAT);

statement error: Cast function cannot convert value of type TIMESTAMP(6) to type FLOAT
SELECT CAST('2000-01-01 00:00:00'::TIMESTAMP AS FLOAT);

statement error: Cast function cannot convert value of type UUID to type FLOAT
SELECT CAST('c4a0327c-44be-416d-ae90-75c05079789f'::UUID AS FLOAT);

statement error: Cast function cannot convert value of type BINARY(1) to type FLOAT
SELECT CAST(x'00'::BINARY AS FLOAT);

statement error: Cast function cannot convert value of type VARBINARY to type FLOAT
SELECT CAST(x'00'::VARBINARY AS FLOAT);

for interval_type in [YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, YEARS, MONTHS, DAYS, HOURS, MINUTES, SECONDS]

statement error: Cast function cannot convert value
SELECT CAST(INTERVAL '11' ${interval_type} AS FLOAT);

endfor

statement error: Cast function cannot convert value of type INTERVAL DAY TO HOUR to type FLOAT
SELECT CAST(INTERVAL '0 01' DAYS TO HOURS AS FLOAT);

statement error: Cast function cannot convert value of type INTERVAL DAY TO MINUTE to type FLOAT
SELECT CAST(INTERVAL '0 01:02' DAYS TO MINUTES AS FLOAT);

statement error: Cast function cannot convert value of type INTERVAL DAY TO SECOND to type FLOAT
SELECT CAST(INTERVAL '0 01:02:03' DAYS TO SECONDS AS FLOAT);

statement error: Cast function cannot convert value of type INTERVAL HOUR TO MINUTE to type FLOAT
SELECT CAST(INTERVAL '00:01' HOURS TO MINUTES AS FLOAT);

statement error: Cast function cannot convert value of type INTERVAL HOUR TO SECOND to type FLOAT
SELECT CAST(INTERVAL '00:01:02' HOURS TO SECONDS AS FLOAT);

statement error: Cast function cannot convert value of type INTERVAL YEAR TO MONTH to type FLOAT
SELECT CAST(INTERVAL '1-0' YEARS TO MONTHS AS FLOAT);