[ https://issues.apache.org/jira/browse/IGNITE-5483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16081964#comment-16081964 ]
ASF GitHub Bot commented on IGNITE-5483: ---------------------------------------- Github user asfgit closed the pull request at: https://github.com/apache/ignite/pull/2248 > SqlQuery fails with WHERE clause on LocalDateTime field > ------------------------------------------------------- > > Key: IGNITE-5483 > URL: https://issues.apache.org/jira/browse/IGNITE-5483 > Project: Ignite > Issue Type: Bug > Components: sql > Affects Versions: 2.0 > Environment: Ignite 2.0.0 > Oracle JDK 1.8.0_121 > Reporter: Benjamin Garaude > Assignee: Sergey Kalashnikov > Fix For: 2.1 > > Attachments: Java8Test_Ignite5483.zip > > > When performing a SqlQuery with a WHERE clause containing an {{=}} predicate > on a field of type LocalDateTime, the query fails with > {{org.apache.ignite.IgniteCheckedException:Failed to execute SQL query.}} > This bug occurred in 2.0, the same SqlQuery was working fine on 1.9. > If we dig into the details,the original exception is a {{ClassCastException}} > on {{IgniteH2Indexing:3663}}. > When doing the same kind of query with a WHERE clause on a String type, it > works. > You can find a test case showing that here: > https://github.com/bgaraude/IgniteTest > I think this is related to IGNITE-4172, but this ticket says that the patch > has to be updated once H2 has been updated. > It seems that ignite 2.0 uses an updated version of H2: 1.4.195. This H2 > version supports LocalDateTime. At least > {{org.h2.value.DataType.getTypeFromClass}} returns TimeStamp for the > LocalDateTime class. But {{IgniteH2Indexing$RowDescriptor.wrap()}} has not > been updated accordingly. Hence, the ClassCastException. > Do you know a workaround i can use while this issue is fixed? -- This message was sent by Atlassian JIRA (v6.4.14#64029)