[jira] [Created] (CALCITE-6536) Dates before BC cannot be used as arguments to date functions

[Caican Cai (Jira)]

Caican Cai created CALCITE-6536:
-----------------------------------

             Summary: Dates before BC cannot be used as arguments to date 
functions
                 Key: CALCITE-6536
                 URL: https://issues.apache.org/jira/browse/CALCITE-6536
             Project: Calcite
          Issue Type: Bug
            Reporter: Caican Cai



{code:java}
    f.checkScalar("date_add(date '000/-12-31', interval 5 day)",
        "000-12-31",
        "DATE NOT NULL");
{code}

org.apache.calcite.runtime.CalciteContextException: From line 1, column 18 to 
line 1, column 34: Illegal DATE literal '000/-12-31': not in format 'yyyy-MM-dd'




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