[ https://issues.apache.org/jira/browse/IGNITE-4172?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16110663#comment-16110663 ]
Alexandr Fedotov edited comment on IGNITE-4172 at 8/2/17 8:12 PM: ------------------------------------------------------------------ Apart from the improvements introduced by [IGNITE-5483|https://issues.apache.org/jira/browse/IGNITE-5483] the following should be addressed: 1. {{java.time.LocalTime}}, {{java.time.LocalDate}}, {{java.time.LocalDateTime}} are not supported as cache values or keys. 2. {{java.time.LocalTime}} is stored as {{java.sql.Time}}, {{java.time.LocalDate}} as {{java.sql.Date}}, {{LocalDateTime}} as {{Timestamp}}. Having, for example, {{IgniteCache<Long, Person>}} where {{Person}} has a {{java.time.LocalDateTime}} field, trying to select that field with a query like {{select locDateTime from Person}} will return {{java.sql.Timestamp}} value. was (Author: asfedotov): Apart from the improvements introduced by [IGNITE-5483|https://issues.apache.org/jira/browse/IGNITE-5483] the following should be addressed: 1. {{java.time.LocalTime}}, {{java.time.LocalDate}}, {{java.time.LocalDateTime}} are not supported as cache values or keys. 2. LocalDateTime is stored as Timestamp, which should be accounted when applying a custom SQL functions. Probably that's a tradeoff for the moment. > 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 > Reporter: Andrew Mashenkov > Assignee: Alexandr Fedotov > Fix For: 2.2 > > > 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; > Startpoint is IgniteH2Indexing.wrap() method. > We need add support to these classes: LocalDate, LocalTime, LocalDateTime. -- This message was sent by Atlassian JIRA (v6.4.14#64029)