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

• Type: Improvement
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 0.8.0, 1.2.0
• Fix Version/s: Future
• Component/s: Execution - Data Types
• Labels: document_if_not_fixed
• Assignee: Unassigned
• Reporter: Victoria Markman
• Created: 15/Jan/15 18:56
• Updated: 08/Oct/15 20:36

Description

t1.json

{ "a1": 1 ,    "b1" : 1}
{ "a1": 2 ,    "b1" : 1}
{ "a1": 2 ,    "b1" : 2}
{ "a1": 3 ,    "b1" : 2}
{ "a1": 5000147483647 , "b1" : 3}

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

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)

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)

Issue Links

• incorporates: DRILL-3278 SUM(CAST(columns[0] AS BIGINT)) OVER(...) gives wrong results