[ignite-3] branch main updated: IGNITE-18754 Use local timezone in ItJdbcResultSetSelfTest#testTimestamp (#1746)

[korlov]

This is an automated email from the ASF dual-hosted git repository.

korlov pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/ignite-3.git


The following commit(s) were added to refs/heads/main by this push:
     new 23563c650f IGNITE-18754 Use local timezone in 
ItJdbcResultSetSelfTest#testTimestamp (#1746)
23563c650f is described below

commit 23563c650f15942a8c39ac5c12f1f18ca9981326
Author: Alexander Polovtcev <alex.polovt...@gmail.com>
AuthorDate: Fri Mar 3 10:57:23 2023 +0200

    IGNITE-18754 Use local timezone in ItJdbcResultSetSelfTest#testTimestamp 
(#1746)
---
 .../apache/ignite/jdbc/ItJdbcResultSetSelfTest.java  | 20 +++++++++++++-------
 1 file changed, 13 insertions(+), 7 deletions(-)

diff --git 
a/modules/jdbc/src/integrationTest/java/org/apache/ignite/jdbc/ItJdbcResultSetSelfTest.java
 
b/modules/jdbc/src/integrationTest/java/org/apache/ignite/jdbc/ItJdbcResultSetSelfTest.java
index e12cbe040e..78d50e6db0 100644
--- 
a/modules/jdbc/src/integrationTest/java/org/apache/ignite/jdbc/ItJdbcResultSetSelfTest.java
+++ 
b/modules/jdbc/src/integrationTest/java/org/apache/ignite/jdbc/ItJdbcResultSetSelfTest.java
@@ -37,7 +37,11 @@ import java.sql.SQLException;
 import java.sql.Statement;
 import java.sql.Time;
 import java.sql.Timestamp;
+import java.time.Instant;
 import java.time.LocalDate;
+import java.time.LocalTime;
+import java.time.ZoneId;
+import java.time.ZonedDateTime;
 import java.util.GregorianCalendar;
 import java.util.UUID;
 import org.apache.ignite.internal.tostring.S;
@@ -555,14 +559,16 @@ public class ItJdbcResultSetSelfTest extends 
AbstractJdbcSelfTest {
 
         assertTrue(rs.next());
 
-        assertEquals(-10800000, rs.getTimestamp("tsVal").getTime());
-        assertEquals(new Date(new Timestamp(-10800000).getTime()), 
rs.getDate(14));
-        assertEquals(new Time(new Timestamp(-10800000).getTime()), 
rs.getTime(14));
-        assertEquals(new Timestamp(-10800000), rs.getTimestamp(14));
+        Instant localEpoch = ZonedDateTime.of(LocalDate.EPOCH, 
LocalTime.MIDNIGHT, ZoneId.systemDefault()).toInstant();
 
-        assertEquals(new Date(new Timestamp(-10800000).getTime()), 
rs.getObject(14, Date.class));
-        assertEquals(new Time(new Timestamp(-10800000).getTime()), 
rs.getObject(14, Time.class));
-        assertEquals(new Timestamp(-10800000), rs.getObject(14, 
Timestamp.class));
+        assertEquals(Timestamp.from(localEpoch), rs.getTimestamp("tsVal"));
+        assertEquals(Date.from(localEpoch), rs.getDate(14));
+        assertEquals(Time.from(localEpoch), rs.getTime(14));
+        assertEquals(Timestamp.from(localEpoch), rs.getTimestamp(14));
+
+        assertEquals(Date.from(localEpoch), rs.getObject(14, Date.class));
+        assertEquals(Time.from(localEpoch), rs.getObject(14, Time.class));
+        assertEquals(Timestamp.from(localEpoch), rs.getObject(14, 
Timestamp.class));
 
         assertFalse(rs.next());
     }