You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2016/12/23 18:24:58 UTC
[jira] [Updated] (CALCITE-1553) Forget to change qualifier when
converting INVERVAL_YEAR literal
[ https://issues.apache.org/jira/browse/CALCITE-1553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde updated CALCITE-1553:
---------------------------------
Description:
If I execute this SQL:
{code}SELECT date '2008-12-31' + INTERVAL '1' YEAR{code}
{{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?
was:
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?
> 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:
> {code}SELECT date '2008-12-31' + INTERVAL '1' YEAR{code}
> {{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)