ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew Mashenkov (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (IGNITE-4172) SQL: Add support for Java 8 Time API classes in date\time functions
Date Tue, 08 Nov 2016 09:42:58 GMT

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

Andrew Mashenkov edited comment on IGNITE-4172 at 11/8/16 9:42 AM:
-------------------------------------------------------------------

I've changed IgniteH2Indexing.wrap() method to support LocalDateTime class. But query result
contains java.sql.TimeStamp objects instead of java.time.LocalDateTime, due to H2 does not
support java8 time api. 

Java8 time objects support will be added in next H2 version. 
To resolve this we need to update H2 version, so this ticket is deferred to ignite 2.0.


was (Author: amashenkov):
I've changed IgniteH2Indexing.wrap() method to support LocalDateTime class. All works fine
for me.

But SQL query result contains java.sql.TimeStamp objects instead of java.time.LocalDateTime,
that may be not obvious to user. 
In H2 future version java8 time objects support will be added. I saw H2 code and it seems
we will face same issue after update dependency.

Thoughts?

> SQL: Add support for Java 8 Time API classes in date\time functions
> -------------------------------------------------------------------
>
>                 Key: IGNITE-4172
>                 URL: https://issues.apache.org/jira/browse/IGNITE-4172
>             Project: Ignite
>          Issue Type: Bug
>    Affects Versions: 1.6, 1.7
>            Reporter: Andrew Mashenkov
>            Assignee: Andrew Mashenkov
>             Fix For: 2.0
>
>
> We have is issue with querying LocalDateTime objects with our SQL engine. 
> Next query can fails with error, if one of row localDateTimeField value has zero-time:

> select DATEDIFF('DAY', localDateTimeField, CURRENT_DATE ()) from t;
> It seems H2 do not support ISO-8601 short time format "HH:mm". We need workaround here.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message