[IMPALA-2086] Incorrect handling of leap years when adding 1 year interval to date

• Type: Bug
• Status: Resolved
• Priority: Blocker
• 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: 20/Jun/15 00:07
• Updated: 15/Dec/15 22:00
• Resolved: 30/Jul/15 00:21

Description

Impala returns incorrect result when the following query is executed:

select CAST('2011-02-28 00:00:00' as TIMESTAMP) + INTERVAL '1' YEAR as stamp;

Impala result:

2012-02-29 00:00:00 

Postgres result:

2012-02-28 00:00:00