You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2023/04/26 16:31:00 UTC
[jira] [Commented] (IGNITE-19272) Uninformative jdbc failure after insertion into TIMESTAMP WITH LOCAL TIMEZONE
[ https://issues.apache.org/jira/browse/IGNITE-19272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17716802#comment-17716802 ]
Evgeny Stanilovsky commented on IGNITE-19272:
---------------------------------------------
probably we need to link them:
https://issues.apache.org/jira/browse/IGNITE-19292
> 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
> Assignee: Andrey Mashenkov
> Priority: Major
> Labels: ignite-3
>
> {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)