[IMPALA-4780] Wrong result with next_day() when codegen is enabled.

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.3.0, Impala 2.5.0, Impala 2.4.0, Impala 2.6.0, Impala 2.7.0, Impala 2.8.0
• Fix Version/s: Impala 2.9.0
• Component/s: Backend
• Labels: codegen
• Target Version: Impala 2.9.0
• Assignee: Michael Ho
• Reporter: Michael Ho
• Created: 18/Jan/17 18:44
• Updated: 09/May/17 23:25
• Resolved: 04/Feb/17 00:00

Description

next_day() keeps returning NULL as it always complains that the interval parameter being added is always too large. It works perfectly fine when codegen is disabled.

Execute the following query with query options: EXEC_SINGLE_NODE_ROWS_THRESHOLD=0 and ENABLE_EXPR_REWRITES=0.

[localhost:21000] > select next_day('2017-01-18', 'Thursday');
Query: select next_day('2017-01-18', 'Thursday')
Query submitted at: 2017-01-18 10:37:00 (Coordinator: http://kwho-desktop:25000)
Query progress can be monitored at: http://kwho-desktop:25000/query_plan?query_id=7e4ad3bce2409928:79899e3100000000
+------------------------------------+
| next_day('2017-01-18', 'thursday') |
+------------------------------------+
| NULL                               |
+------------------------------------+
WARNINGS: UDF WARNING: Cannot add interval 1: Interval value too large

Fetched 1 row(s) in 0.22s
[localhost:21000] > set disable_codegen=true;
DISABLE_CODEGEN set to true
[localhost:21000] > select next_day('2017-01-18', 'Thursday');
Query: select next_day('2017-01-18', 'Thursday')
Query submitted at: 2017-01-18 10:37:07 (Coordinator: http://kwho-desktop:25000)
Query progress can be monitored at: http://kwho-desktop:25000/query_plan?query_id=24454a20d73fed3c:8fef716700000000
+------------------------------------+
| next_day('2017-01-18', 'thursday') |
+------------------------------------+
| 2017-01-19 00:00:00                |
+------------------------------------+
Fetched 1 row(s) in 0.01s