[jira] [Commented] (IGNITE-5483) SqlQuery fails with WHERE clause on LocalDateTime field
[ 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)
[jira] [Commented] (IGNITE-5483) SqlQuery fails with WHERE clause on LocalDateTime field
[ https://issues.apache.org/jira/browse/IGNITE-5483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16075066#comment-16075066 ] ASF GitHub Bot commented on IGNITE-5483: GitHub user skalashnikov opened a pull request: https://github.com/apache/ignite/pull/2248 IGNITE-5483: SQL: Added limited support for Java8 LocalDateTime You can merge this pull request into a Git repository by running: $ git pull https://github.com/gridgain/apache-ignite ignite-5483 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/ignite/pull/2248.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #2248 commit a5abdd579cc7ace5d17ebcc6555e3ce66c777917 Author: Vasiliy Sisko Date: 2017-07-04T11:44:42Z ignite-2.1 Fixed minor issues and typos. commit 6c9d2228d2aba6ba5be64bd20ef244e634aeaa5a Author: Alexey Kuznetsov Date: 2017-07-04T12:30:46Z ignite-2.1 Added persistent store metrics. commit f39129020999561e9def300b9cc136138ea3698e Author: Andrey V. Mashenkov Date: 2017-06-16T16:54:26Z IGNITE-5527: Prevent starvation in stripe pool on unstable topology. (cherry picked from commit 97ea507) commit b69f53e0ccf9d3da42a99d4423fb3d8bdd60a7bb Author: Pavel Tupitsyn Date: 2017-07-04T14:42:31Z IGNITE-5629 .NET: CacheConfiguration copy constructor commit 2e7adbfbbab62f3b98e0409d2f4ceabad89b4120 Author: agura Date: 2017-07-04T13:56:40Z ignite-5685 JDBC prepared statement shouldn't clear parameters after execution commit 9743fa3d711d0f1bbf0fa7ceec65237879f76d0d Author: Ilya Lantukh Date: 2017-07-04T15:10:25Z Muted hanging tests. commit 114c42e14013fe5b7bd6f186f7db59a533d61f68 Author: Alexey Goncharuk Date: 2017-07-04T16:35:06Z Cosmetic changes commit 77c5dc7455b9bf020dee549cc91286a897dbfdbc Author: Dmitriy Govorukhin Date: 2017-07-04T16:40:21Z Added onCacheGroupStopped callback commit ee7566b1063de69ca4f261ee2088d69d231b1c2a Author: Dmitriy Govorukhin Date: 2017-07-04T17:00:09Z Minor code cleanup commit 44f3fac27bec89b5e70e87564c527e48565ddd2a Author: dpavlov Date: 2017-07-04T17:23:40Z IGNITE-5558 - Added ability to read WAL in standalone mode - Fixes #2174. Signed-off-by: Alexey Goncharuk commit 90b67fa1b72b096943499e26e402988840bdbe97 Author: Sergey Chugunov Date: 2017-07-04T17:47:09Z IGNITE-4536 two tests unmuted, one test removed as obsolete (IGNITE-5592) - Fixes #2235. Signed-off-by: Alexey Goncharuk commit 50bb0901255707dc9601159803363a36aeafecab Author: Ilya Lantukh Date: 2017-07-04T15:10:25Z Muted hanging tests. commit 5b7165ca717de038249570c4213f050ba9b5aee7 Author: Ilya Lantukh Date: 2017-07-04T17:57:56Z IGNITE-5693 - Fixed semaphore flaky test - Fixes #2239. Signed-off-by: Alexey Goncharuk commit 54572c3023dc03a55621fbb4754888b081791e31 Author: tledkov-gridgain Date: 2017-07-05T07:30:48Z IGNITE-5340: Improved IgniteCacheAbstractQuerySelfTest to better test non-standard index names. This closes #2206. commit 44fad244aa40f552159af153fefdf25d47c7375e Author: tledkov-gridgain Date: 2017-07-05T08:18:48Z IGNITE-5426: JdbcThinConnection.readOnly state propagation. This closes #2200. commit 1337901f04c866e20093b20449c0872f089fb64b Author: sboikov Date: 2017-07-05T08:19:43Z Reworked cluster activation/deactivation. commit b67b8c4438f240038b61ca65b947394106b0e43b Author: sboikov Date: 2017-07-05T08:20:54Z Merge remote-tracking branch 'origin/ignite-2.1' into ignite-2.1 commit f9f13cf083b481f004531710ec3835afdf5b7cef Author: Pavel Tupitsyn Date: 2017-07-05T09:59:43Z IGNITE-5605 .NET: Inject resources into remote event filters commit aa21a9b59ec0266b4fee16e02d2796e6e0d1a9b5 Author: devozerov Date: 2017-07-05T11:18:32Z Merge branch 'ignite-2.1' into ignite-2.1.2 commit 301f310b6348b3f6fbe54b16d065569755e71bce Author: Igor Sapego Date: 2017-07-04T16:42:33Z IGNITE-5663: ODBC: Closing cursor do not reset prepared statement anymore (cherry picked from commit 64c156e) commit 58a937e5310c62ccb557d8da959bc4ffa8bcca62 Author: sboikov Date: 2017-07-05T11:24:51Z Diagnostic info for GridDhtTxFinishFuture. commit 0f9a895a04cd4a4f6be8e006fc2afd6f720b2215 Author: sboikov Date: 2017-07-05T11:25:16Z Merge remote-tracking branch 'community/ignite-2.1.2' into ignite-2.1.2 commit 15da654a3e5c2bbf14947f0d3dd08270a9ba6766 Author: Alexander Paschenko Date: 2017-07-05T12:15:35Z IGNITE-5187: Improved DynamicIndexAbstractConcurrentSelfTest reliability. This closes #2219. commit 0357c51c68540fc14de83ea36f0cfdc7ec987b80 Author: sboikov Date: 2017-07-05T13:59:23Z ignite-2.1 Do not use 'compress' flag for GridDhtPartitionsFullMessage send in discovery messa
[jira] [Commented] (IGNITE-5483) SqlQuery fails with WHERE clause on LocalDateTime field
[ https://issues.apache.org/jira/browse/IGNITE-5483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16049713#comment-16049713 ] Denis Magda commented on IGNITE-5483: - [~sergi.vladykin], [~sergi.vladykin], please stop by here. > 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 > Fix For: 2.1 > > > 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)