You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Baofeng Zhang (JIRA)" <ji...@apache.org> on 2016/12/23 10:01:58 UTC

[jira] [Created] (CALCITE-1553) Forget to change qualifier when converting INVERVAL_YEAR literal

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)