[IMPALA-2260] Crash: timestamp-functions.cc:641 - Check failed: result_value > input_value

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 2.3.0
• Fix Version/s: Impala 2.3.0, Impala 2.2.9
• Labels: crash query_generator
• Target Version: Impala 2.3.0, Impala 2.2.9
• Assignee: casey
• Reporter: Taras Bobrovytsky
• Created: 27/Aug/15 21:15
• Updated: 15/Dec/15 22:00
• Resolved: 09/Oct/15 22:29

Description

DB: functional

Query:

SELECT
COALESCE(t1.tinyint_col, t1.year, t2.int_col) AS int_col,
CAST('1997-11-16 00:00:00' AS TIMESTAMP) + INTERVAL COUNT(t1.year) MONTH AS timestamp_col,
MAX(t2.timestamp_col) AS timestamp_col_1,
(t2.int_col) * (t1.month) AS int_col_1,
CAST((-870) + (FIRST_VALUE(-221) OVER (ORDER BY COALESCE(t1.tinyint_col, t1.year, t2.int_col), (t2.int_col) * (t1.month) DESC ROWS BETWEEN 82 FOLLOWING AND UNBOUNDED FOLLOWING)) AS STRING) AS char_col
FROM alltypestiny t1
LEFT JOIN (
SELECT
COALESCE(month, year, id) AS int_col,
CAST(month AS STRING) AS char_col,
CAST('2027-02-11 00:00:00' AS TIMESTAMP) + INTERVAL SUM(364) OVER () HOUR AS timestamp_col
FROM alltypesagg
) t2 ON ((t2.timestamp_col) = (t1.timestamp_col)) AND ((t2.int_col) = (t1.month))
GROUP BY
COALESCE(t1.tinyint_col, t1.year, t2.int_col),
(t2.int_col) * (t1.month)

This query causes a crash every time it is executed, so it's easy to reproduce. I was unable to extract the stack trace.

From impalad.Fatal:

F0827 14:04:28.049944 22625 timestamp-functions.cc:641] Check failed: result_value > input_value (1899-05-02 08:25:26.290448384 vs. 2027-02-11 00:00:00)