[IGNITE-5483] SqlQuery fails with WHERE clause on LocalDateTime field

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0
• Fix Version/s: 2.1
• Component/s: sql

Environment

Ignite 2.0.0
Oracle JDK 1.8.0_121

• Assignee: Sergey Kalashnikov
• Reporter: Benjamin Garaude
• Created: 14/Jun/17 07:42
• Updated: 28/Jul/17 14:13
• Resolved: 07/Jul/17 11:41

Description

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?

Issue Links

• is related to: IGNITE-4172 SQL: Add support for Java 8 Time API classes in date\time functions
• links to: GitHub Pull Request #2248