[ 
https://issues.apache.org/jira/browse/IGNITE-15623?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Evgeny Stanilovsky updated IGNITE-15623:
----------------------------------------
    Description: 
{noformat}
statement ok
CREATE TABLE timestamp(t TIMESTAMP)
{noformat}
{noformat}
/sql/types/timestamp/test_incorrect_timestamp.test
{noformat}
{noformat}
INSERT INTO timestamp VALUES ('1900-02-35 00:00:00')  <-- need to fail, but 
smartly converted instead.{noformat}

  was:

{noformat}
statement ok
CREATE TABLE timestamp(t TIMESTAMP)
{noformat}


{noformat}
/sql/types/timestamp/test_incorrect_timestamp.test
{noformat}



{noformat}
Statement: Statement [queries=ArrayList [CREATE TABLE timestamp(t TIMESTAMP)], 
expected=OK]

        at 
org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner$Statement.execute(SqlScriptRunner.java:404)
        at 
org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner.run(SqlScriptRunner.java:115)
        at 
org.apache.ignite.internal.processors.query.calcite.logical.ScriptTestRunner$1.run(ScriptTestRunner.java:219)
        at java.lang.Thread.run(Thread.java:748)
Caused by: class 
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse 
query.
{noformat}



> Calcite. Reject erroneous datetime literals.
> --------------------------------------------
>
>                 Key: IGNITE-15623
>                 URL: https://issues.apache.org/jira/browse/IGNITE-15623
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Evgeny Stanilovsky
>            Assignee: Evgeny Stanilovsky
>            Priority: Major
>              Labels: calcite, calcite2-required, calcite3-required, ignite-3
>
> {noformat}
> statement ok
> CREATE TABLE timestamp(t TIMESTAMP)
> {noformat}
> {noformat}
> /sql/types/timestamp/test_incorrect_timestamp.test
> {noformat}
> {noformat}
> INSERT INTO timestamp VALUES ('1900-02-35 00:00:00')  <-- need to fail, but 
> smartly converted instead.{noformat}



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

Reply via email to