[CALCITE-3383] Allow plural time units in interval literals

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 30/Sep/19 23:40
• Updated: 06/Mar/20 04:33
• Resolved: 11/Oct/19 00:54

Description

Allow plural time units in interval literals. For example, currently, Calcite allows INTERVAL '2' DAY but gives an error for INTERVAL '2' DAYS. (Note: DAY vs DAYS.)

Standard SQL only allows the first; PostgreSQL allows both.