[jira] [Commented] (IGNITE-16181) Calcite engine. Handle arithmetic overflows

["Ignite TC Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-16181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17690350#comment-17690350 ] 

Ignite TC Bot commented on IGNITE-16181:
----------------------------------------

{panel:title=Branch: [pull/10541/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/10541/head] Base: [master] : New Tests (2)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL{color} [[tests 2|https://ci2.ignite.apache.org/viewLog.html?buildId=7050938]]
* {color:#013220}IgniteCalciteTestSuite: StdSqlOperatorsTest.testArithmeticOverflow - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite: TableDmlIntegrationTest.testInsertValueOverflow - PASSED{color}

{panel}
[TeamCity *--> Run :: All* Results|https://ci2.ignite.apache.org/viewLog.html?buildId=7051020&buildTypeId=IgniteTests24Java8_RunAll]

> Calcite engine. Handle arithmetic overflows
> -------------------------------------------
>
>                 Key: IGNITE-16181
>                 URL: https://issues.apache.org/jira/browse/IGNITE-16181
>             Project: Ignite
>          Issue Type: Improvement
>            Reporter: Aleksey Plekhanov
>            Assignee: Ilhom Ulmasov
>            Priority: Major
>              Labels: calcite2-required, calcite3-required, ise
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> Currently, we silently ignore arithmetic overflows and return the wrong result, for example:
> {noformat}
> SELECT 2147483647 + 2147483647{noformat}
> Returns -2. But SQL standard says that exception should be thrown:
> {noformat}
> 5) If the most specific type of the result of an arithmetic operation is exact numeric, then Case:
> a) If the operator is not division and the mathematical result of the operation is not exactly representable with the precision and scale of the result data type, then an exception condition is raised: data exception — numeric value out of range.{noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)