[CALCITE-5495] Allow WEEK and QUARTER in INTERVAL literals

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.33.0
• Assignee: Tanner Clary
• Reporter: Julian Hyde
• Created: 25/Jan/23 06:55
• Updated: 26/Jul/23 21:32
• Resolved: 25/Jan/23 07:42

Description

Allow interval literals denominated in weeks and quarters, for example:

INTERVAL '1' WEEK
INTERVAL '2' WEEKS
INTERVAL '3' QUARTERS
INTERVAL '4' QUARTER

Week intervals have type INTERVAL DAY (a week is 7 days); quarter intervals have type INTERVAL MONTH (a quarter is 3 months).

Issue Links

• relates to: CALCITE-5864 getValueAs reports the wrong number of milliseconds for WEEK and the wrong number of months for QUARTER