[jira] [Created] (DRILL-2015) Casting numeric value that does not fit in integer data type produces incorrect result

["Victoria Markman (JIRA)" <ji...@apache.org>]

Victoria Markman created DRILL-2015:
---------------------------------------

             Summary: Casting numeric value that does not fit in integer data type produces incorrect result
                 Key: DRILL-2015
                 URL: https://issues.apache.org/jira/browse/DRILL-2015
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Data Types
    Affects Versions: 0.8.0
            Reporter: Victoria Markman
            Assignee: Daniel Barclay (Drill/MapR)
            Priority: Critical


t1.json
{code}
{ "a1": 1 ,    "b1" : 1}
{ "a1": 2 ,    "b1" : 1}
{ "a1": 2 ,    "b1" : 2}
{ "a1": 3 ,    "b1" : 2}
{ "a1": 5000147483647 , "b1" : 3}
{code}

We should throw an error, this is technically data corruption.

{code}
0: jdbc:drill:schema=dfs> select cast(a1 as integer) from `t1.json`;
+------------+
|   EXPR$0   |
+------------+
| 1          |
| 2          |
| 2          |
| 3          |
| 805551103  |
+------------+
5 rows selected (0.074 seconds)
{code}

{code}
0: jdbc:drill:schema=dfs> select cast(2147483648 as integer) from `t1.json`;
+------------+
|   EXPR$0   |
+------------+
| -2147483648 |
| -2147483648 |
| -2147483648 |
| -2147483648 |
| -2147483648 |
+------------+
5 rows selected (0.076 seconds)
{code}




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