[jira] [Created] (CALCITE-6134) Can't parse custom function with name 'DATEADD' in babel

[SimonAlexs (Jira)]

SimonAlexs created CALCITE-6134:
-----------------------------------

             Summary: Can't parse custom function with name 'DATEADD' in babel
                 Key: CALCITE-6134
                 URL: https://issues.apache.org/jira/browse/CALCITE-6134
             Project: Calcite
          Issue Type: Bug
          Components: babel
    Affects Versions: 1.36.0
            Reporter: SimonAlexs


h4. *1. config*

    I use SqlBabelParserImpl.FACTORY, and create SqlCustomOperatorTable.java 
which extends org.apache.calcite.sql.fun.SqlStdOperatorTable.
{code:java}
Frameworks.newConfigBuilder()
        .parserConfig(SqlParser.config()
                .withLex(Lex.MYSQL)
                .withCaseSensitive(false)
                .withConformance(SqlConformanceEnum.MYSQL_5)
                .withParserFactory(SqlBabelParserImpl.FACTORY)
        )
        .operatorTable(SqlCustomOperatorTable.instance()) {code}
    In my SqlCustomOperatorTable, I define my custom function named with 
'DATEADD'. 
h4. *2. error*

    When i try the sql below, i got error as follows.
{code:java}
select dateadd(1698389166000, interval 1 year) {code}
{code:java}
Encountered "1698389166000" at line 1, column 16.
Was expecting one of:
    <IDENTIFIER> ...
    <HYPHENATED_IDENTIFIER> ...
    <QUOTED_IDENTIFIER> ...
    <BACK_QUOTED_IDENTIFIER> ...
    <BIG_QUERY_BACK_QUOTED_IDENTIFIER> ...
    <BRACKET_QUOTED_IDENTIFIER> ...
    <UNICODE_QUOTED_IDENTIFIER> ... {code}
    Is 'DATEADD' a reserved word? Is there any method to let me create a custom 
function with name 'DATEADD'?

    Thanks for your help.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)