[IMPALA-2633] Inconsistent handling of out-of-range values in integer casts

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: Impala 2.3.0
• Component/s: Backend
• Labels: correctness downgraded
• Epic Link: Numeric Datatype Conversions
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Tim Armstrong
• Created: 04/Nov/15 22:33
• Updated: 13/Aug/20 21:15
• Resolved: 13/Aug/20 21:15

Description

John Russell discovered some odd behaviour in casttoint. In some cases it returns NULL when the input is an out-of-range value. In others it returns the overflowed value.

[tarmstrong-box.ca.cloudera.com:21000] > select casttoint(hex('1F603'));
Query: select casttoint(hex('1F603'))
+-------------------------+
| casttoint(hex('1f603')) |
+-------------------------+
| NULL                    |
+-------------------------+
Fetched 1 row(s) in 0.01s
[tarmstrong-box.ca.cloudera.com:21000] > select hex('1F603');
Query: select hex('1F603')
+--------------+
| hex('1f603') |
+--------------+
| 3146363033   |
+--------------+
Fetched 1 row(s) in 0.01s
[tarmstrong-box.ca.cloudera.com:21000] > select casttoint(3146363033);
Query: select casttoint(3146363033)
+-----------------------+
| casttoint(3146363033) |
+-----------------------+
| -1148604263           |
+-----------------------+
Fetched 1 row(s) in 0.01s

Issue Links

• duplicates: IMPALA-2710 Overflows during expr evaluation should result in an error or null
• relates to: IMPALA-865 Impala will return incorrect result on int overflow without warning
• relates to: IMPALA-2710 Overflows during expr evaluation should result in an error or null