[jira] [Created] (IGNITE-4362) DML: the multiplication for SET uses the data type for the result from the right side

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (IGNITE-4362) DML: the multiplication for SET uses the data type for the result from the right side

Anton Vinogradov (Jira)
Sergey Kozlov created IGNITE-4362:
-------------------------------------

             Summary: DML: the multiplication for SET uses the data type for the result from the right side
                 Key: IGNITE-4362
                 URL: https://issues.apache.org/jira/browse/IGNITE-4362
             Project: Ignite
          Issue Type: Bug
            Reporter: Sergey Kozlov


Lets run following statement:
{{update AllTypes set longCol = shortCol*100000 where _key = ?}}

The exception below has been thrown if {{shortCol*100000}} violates the short integer borders:

{noformat}
Caused by: org.h2.jdbc.JdbcSQLException: ... "-46000"
Numeric value out of range: "-46000"; SQL statement:
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)