[jira] [Created] (IGNITE-19272) Uninformative jdbc failure after insertion into TIMESTAMP WITH LOCAL TIMEZONE

["Evgeny Stanilovsky (Jira)" <ji...@apache.org>]

Evgeny Stanilovsky created IGNITE-19272:
-------------------------------------------

             Summary: Uninformative jdbc failure after insertion into TIMESTAMP WITH LOCAL TIMEZONE
                 Key: IGNITE-19272
                 URL: https://issues.apache.org/jira/browse/IGNITE-19272
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 3.0.0-beta1
            Reporter: Evgeny Stanilovsky



{code:java}
try (Statement stmt = conn.createStatement()) {
stmt.executeUpdate("CREATE TABLE timetest(id INT PRIMARY KEY,"
                    + "ts TIMESTAMP, ts_tz TIMESTAMP WITH LOCAL TIME ZONE)");

            stmt.executeUpdate("INSERT INTO timetest VALUES "
                    + "(3, '2011-01-01 01:01:01', TIMESTAMP WITH LOCAL TIME ZONE '2011-01-01 01:01:01')"); // <- ok
            stmt.executeUpdate("INSERT INTO timetest VALUES "
                    + "(1, '2011-01-01 01:01:01', '2011-01-01 01:01:01')"); // <- failed

}
{code}

failed with no reason why:

{noformat}
java.sql.SQLException: Exception while executing query [query=INSERT INTO timetest VALUES (3, '2011-01-01 01:01:01', '2011-01-01 01:01:01')]. Error message:IGN-CMN-65535 TraceId:ba72bbc8-a0e3-414b-a520-6eed739b3f45 Remote query execution

	at org.apache.ignite.internal.jdbc.proto.IgniteQueryErrorCode.createJdbcSqlException(IgniteQueryErrorCode.java:57)
	at org.apache.ignite.internal.jdbc.JdbcStatement.execute0(JdbcStatement.java:148)
	at org.apache.ignite.internal.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:177)
{noformat}





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