[
https://issues.apache.org/jira/browse/IGNITE-22519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-22519:
--------------------------------------
Fix Version/s: 3.0.0-beta2
> 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
> Assignee: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
> Fix For: 3.0.0-beta2
>
> Time Spent: 1h 20m
> Remaining Estimate: 0h
>
> 1.
> {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)
