Re: Bug on convert INTERVAL_YEAR literal

[Julian Hyde]

That sounds like a bug. Can you please log a JIRA case with a test case?

> On Dec 22, 2016, at 7:28 PM, baofeng.zbf <baofeng....@alibaba-inc.com> wrote:
> 
> 
> Hi,
> 
> Found a bug on parse "SELECT date '2008-12-31' + INTERVAL '1' YEAR” to 
> SqlNode, 
> 
> for the INTERVAL ‘1’ YEAR is converted to INTERVAL ‘12’ YEAR in 
> SqlNodeToRexConverterImpl:
> 
> Inside convertLiteral method, the value is multiplied by 12 to month, but 
> qualifier is still YEAR, forget to change to MONTH.
> 
> Thx,
> Baofeng Zhang