[CALCITE-1553] Forget to change qualifier when converting INVERVAL_YEAR literal

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Fix Version/s: 1.11.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: Baofeng Zhang
• Created: 23/Dec/16 10:01
• Updated: 06/Jan/17 19:32
• Resolved: 27/Dec/16 01:53

Description

If I execute this SQL:

SELECT date '2008-12-31' + INTERVAL '1' YEAR

INTERVAL '1' YEAR is converted into INTERVAL '12' YEAR inside SqlNodeToRexConverterImpl.convertLiteral method, which forgets to change qualifier to MONTH.

Besides INTERVAL_YEAR_MONTH, there maybe other SqlTypeFamily have the same problem.

In addition, can we expose SqlNodeToRexConverter in SqlToRelConverter to let developer to plugin their own converter?

Issue Links

• links to: Dev branch