You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Caican Cai (Jira)" <ji...@apache.org> on 2024/08/19 14:21:00 UTC

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

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)