Baofeng Zhang created CALCITE-1553:
--------------------------------------
Summary: Forget to change qualifier when converting INVERVAL_YEAR
literal
Key: CALCITE-1553
URL: https://issues.apache.org/jira/browse/CALCITE-1553
Project: Calcite
Issue Type: Bug
Components: core
Reporter: Baofeng Zhang
Assignee: Julian Hyde
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?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)