[IGNITE-12312] JDBC thin: it's not possible to use LocalDate/LocalTime/LocalDateTime as value in where _key=<value>.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: ise
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Alexander Lapin
• Created: 21/Oct/19 16:03
• Updated: 21/Mar/22 07:06

Description

JDBC thin: it's not possible to use LocalDateTime (converted internally to java.sql.Timestamp) as value in where _key=<Timestamp>.
In case of following query
 

stmt.executeQuery("SELECT * FROM " + tableName +" where _key >= PARSEDATETIME('2019-09-05 17:43:01.144', 'yyyy-MM-dd HH:mm:ss.SSS') and _key <= PARSEDATETIME('2019-09-05 17:43:01.144', 'yyyy-MM-dd HH:mm:ss.SSS')");

expected row would be returned, however in case of
 

stmt.executeQuery("SELECT * FROM " + tableName +" where _key = PARSEDATETIME('2019-09-05 17:43:01.144', 'yyyy-MM-dd HH:mm:ss.SSS')");

no rows would be returned.

Reproducers:

org.apache.ignite.jdbc.thin.JdbcThinCacheToJdbcDataTypesCoverageTest#testLocalDateTimeDataType

org.apache.ignite.jdbc.thin.JdbcThinCacheToJdbcDataTypesCoverageTest#testLocalTimeDataType

org.apache.ignite.jdbc.thin.JdbcThinCacheToJdbcDataTypesCoverageTest#testLocalDateDataType