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)