[IMPALA-2090] Incorrect handling of leap years when adding 1 month interval to date

• 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: correctness query_generator
• Target Version: Impala 2.3.0, Impala 2.2.9
• Assignee: casey
• Reporter: Taras Bobrovytsky
• Created: 22/Jun/15 20:51
• Updated: 15/Dec/15 22:00
• Resolved: 30/Jul/15 00:22

Description

Impala returns incorrect result when the following query is executed:

select CAST('2012-02-29 00:00:00' as TIMESTAMP) + INTERVAL 1 MONTH as stamp;

Impala Result:

+---------------------+
| stamp               |
+---------------------+
| 2012-03-31 00:00:00 |
+---------------------+

Postgres Result:

        stamp        
---------------------
 2012-03-29 00:00:00
(1 row)