Description
1.
SELECT CAST('100.1' AS BIGINT);
Values(tuples=[[{ 100 }]]):
Expected result
It should be an error because '100.1' can not be converted to BIGINT/long.
2.
SELECT CAST(1e39 AS REAL);
Values(tuples=[[{ 1E39 }]]):
Expected result
Should be an overflow error
3.
SELECT CAST(1e39 AS FLOAT);
Values(tuples=[[{ 1E39 }]]):
Expected result
Should be an overflow error
Attachments
Issue Links
- fixes
-
IGNITE-19822 Sql. CAST(literal AS decimal_type) is reduced to literal when type(lateral).scale != decimal_type.scale
-
- Resolved
-
- is caused by
-
-
- Closed
-
- links to
