[CALCITE-308] Wrong result when using DATE+INTERVAL arithmetics

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.9.0
• Assignee: Julian Hyde
• Reporter: Vladimir Sitnikov
• Created: 21/Jun/14 06:09
• Updated: 27/Feb/24 22:23
• Resolved: 27/Jun/16 21:04

Description

Test: date '2014-06-19' + interval '1' year

java.lang.AssertionError: 
Expected :[2015-06-19]
Actual   :[2014-06-31]

Generated java code:

/*  23 */  public Object current() {
/*  24 */    return $L4J$C$16240_12;
/*  25 */  }
/*  26 */ 
/*  27 */  static final int $L4J$C$16240_12 = 16240 + 12; // !!!  interval '1' year is converted to 12 months and 12 gets added to the number of days

Additional test – JdbcTest.testWinIntervalFrame

Issue Links

• relates to: CALCITE-304 Support '<DATE> + <INTEGER>' operator