carton.swing created CALCITE-5352:
-------------------------------------
Summary: Babel parser does not recogize quote string with
DATE_PART function
Key: CALCITE-5352
URL: https://issues.apache.org/jira/browse/CALCITE-5352
Project: Calcite
Issue Type: Bug
Reporter: carton.swing
While using babel parser(calcite-babel's SqlBabelParserImpl) to parse
PostgreSQL syntax:
{code:java}
planner.parse("SELECT DATE_PART('week', TIMESTAMP '2022-10-31')"){code}
it will throws exception.
But if I use:
{code:java}
planner.parse("SELECT DATE_PART(week, TIMESTAMP '2022-10-31')"){code}
the parser works well.
However, the former syntax, which is a quote-string, is correct according to :
[https://www.postgresql.org/docs/9.1/functions-datetime.html]
|{{{{date_part({{{}text{}}}, {{{}timestamp{}}})}}}}|
the first argument should be a a quote string instead of a TimeUnit token.
Is there something I'm missing?
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
