Alexander Lapin created IGNITE-12312: ----------------------------------------
Summary: JDBC thin: it's not possible to use LocalDate/LocalTime/LocalDateTime as value in where _key=<value>. Key: IGNITE-12312 URL: https://issues.apache.org/jira/browse/IGNITE-12312 Project: Ignite Issue Type: Bug Reporter: Alexander Lapin 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 {color:#172b4d}{{stmt.{color:#172b4d}executeQuery{color}({color:#36b37e}"SELECT * FROM "{color} + tableName +{color:#36b37e}" 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')"{color});}}{color} expected row would be returned, however in case of {color:#172b4d}{{stmt.{color:#172b4d}executeQuery{color}({color:#36b37e}"SELECT * FROM "{color} + tableName +{color:#36b37e}" where _key = PARSEDATETIME('2019-09-05 17:43:01.144', 'yyyy-MM-dd HH:mm:ss.SSS')"{color});}}{color} 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 -- This message was sent by Atlassian Jira (v8.3.4#803005)