ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Lapin (Jira)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-12312) JDBC thin: it's not possible to use LocalDate/LocalTime/LocalDateTime as value in where _key=<value>.
Date Mon, 21 Oct 2019 16:04:00 GMT
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)

Mime
View raw message