[jira] [Commented] (IGNITE-7363) Inconsistent millis in java.util.Date when retrieved in SELECT query

["Ilya Kasnacheev (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-7363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16318605#comment-16318605 ] 

Ilya Kasnacheev commented on IGNITE-7363:
-----------------------------------------

It probably has to do with H2 type conversions, especially DateTimeUtils.

> Inconsistent millis in java.util.Date when retrieved in SELECT query
> --------------------------------------------------------------------
>
>                 Key: IGNITE-7363
>                 URL: https://issues.apache.org/jira/browse/IGNITE-7363
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 2.3
>            Reporter: Ilya Kasnacheev
>         Attachments: 19222.zip
>
>
> ~ when querying for java.util.Date field in SELECT query it returns a java.sql.Timestamp, and when getTime() on that Timestamp is called it returns different milliseconds value than in original java.util.Date, in case Time Zone is different on client and on server. Using get() the correct java.util.Date is obtained. Please see reproducer, kudos http://apache-ignite-users.70518.x6.nabble.com/Date-type-field-in-select-query-is-returning-wrong-value-when-Time-zones-of-Ignite-Client-and-Servert-tc19222.html



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)