Runkang He created CALCITE-5990:
-----------------------------------

             Summary: Explicit cast to numeric type doesn't check overflow
                 Key: CALCITE-5990
                 URL: https://issues.apache.org/jira/browse/CALCITE-5990
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.35.0
            Reporter: Runkang He


Explicit cast to numeric type doesn't check overflow, and this issue can be 
reproduced by sqlline:
{code:sql}
select cast(empno as tinyint), cast(130 as tinyint) from emps where 
name='Alice'; -- empno is 130
{code}
The result is:
{code:sql}
-126, -126{code}
I think it should throw exception when overflow.
At last, this issue was found when to turn on runtime check for 
CalciteSqlOperatorTest in CALCITE-5921.



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

Reply via email to