You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2023/04/14 06:04:00 UTC

[jira] [Commented] (IGNITE-18345) SQL. Cannot use java Date/Time API classes as parameters for query

    [ https://issues.apache.org/jira/browse/IGNITE-18345?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17712199#comment-17712199 ] 

Evgeny Stanilovsky commented on IGNITE-18345:
---------------------------------------------

[~jooger]  [~korlov]  guys can u make a review plz?

> SQL. Cannot use java Date/Time API classes as parameters for query
> ------------------------------------------------------------------
>
>                 Key: IGNITE-18345
>                 URL: https://issues.apache.org/jira/browse/IGNITE-18345
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>            Reporter: Yury Gerzhedovich
>            Assignee: Evgeny Stanilovsky
>            Priority: Major
>              Labels: calcite, ignite-3
>
> Simple broken scenario looks as
> {code:java}
>         assertQuery("SELECT LAST_DAY(?)").withParams(Date.valueOf("2022-01-01"))
>                 .returns(Date.valueOf("2022-01-31")).check();
> {code}
> In the case we have the following error:
> {code:java}
> org.apache.ignite.lang.IgniteException: IGN-CMN-65535 TraceId:86aeab6a-5aa9-4f4e-a69d-5809e53f60b9 class java.lang.Integer cannot be cast to class java.lang.Long (java.lang.Integer and java.lang.Long are in module java.base of loader 'bootstrap'){code}
> The ticket included also new java time API like LocalDateTime and so one



--
This message was sent by Atlassian Jira
(v8.20.10#820010)