[
https://issues.apache.org/jira/browse/IGNITE-22519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-22519:
--------------------------------------
Description:
1. The following query returns 100:
{noformat}
SELECT CAST('100.1' AS BIGINT);
Values(tuples=[[{ 100 }]]):
{noformat}
*Expected result*
It should be an error because '100.1' can not be converted to BIGINT/long.
2.
{noformat}
SELECT CAST(1e39 AS REAL);
Values(tuples=[[{ 1E39 }]]):
{noformat}
*Expected result*
Should be an overflow error
3.
{noformat}
SELECT CAST(1e39 AS FLOAT);
Values(tuples=[[{ 1E39 }]]):
{noformat}
*Expected result*
Should be an overflow error
was:
The following query returns 100:
{noformat}
SELECT CAST('100.1' AS BIGINT);
Values(tuples=[[{ 100 }]]):
{noformat}
*Expected result*
It should be an error because '100.1' can not be converted to BIGINT/long.
> Sql. Numerics. Conversion produces incorrect results
> ----------------------------------------------------
>
> Key: IGNITE-22519
> URL: https://issues.apache.org/jira/browse/IGNITE-22519
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
>
> 1. The following query returns 100:
> {noformat}
> SELECT CAST('100.1' AS BIGINT);
> Values(tuples=[[{ 100 }]]):
> {noformat}
> *Expected result*
> It should be an error because '100.1' can not be converted to BIGINT/long.
> 2.
> {noformat}
> SELECT CAST(1e39 AS REAL);
> Values(tuples=[[{ 1E39 }]]):
> {noformat}
> *Expected result*
> Should be an overflow error
> 3.
> {noformat}
> SELECT CAST(1e39 AS FLOAT);
> Values(tuples=[[{ 1E39 }]]):
> {noformat}
> *Expected result*
> Should be an overflow error
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
