[CALCITE-1632] Return type of "datetime + interval" expression

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.12.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 14/Feb/17 20:35
• Updated: 24/Mar/17 03:20
• Resolved: 15/Feb/17 17:41

Description

Per the SQL standard, the return type of "datetime + interval" is the same as the type of "datetime". (Postgres, for instance, always widens the result to TIMESTAMP; this is wrong.)

Also, when adding or subtracting to a TIME value, make sure the result stays within the range 00:00:00..23:59:59.