[jira] [Commented] (IGNITE-6286) org.h2.jdbc.JdbcSQLException: Hexadecimal string with odd number of characters

["Sergey Chernolyas (JIRA)" <ji...@apache.org>]

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

Sergey Chernolyas commented on IGNITE-6286:
-------------------------------------------

Reproduce exception by test IgniteSqlParameterQueryTest

______________________
[2017-09-21 23:17:58,873][ERROR][query-#184%query.IgniteSqlParameterQueryTest0%][GridMapQueryExecutor] Failed to execute local query.
class org.apache.ignite.IgniteCheckedException: Failed to execute SQL query.
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:970)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1029)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1008)
        at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:660)
        at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:506)
        at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:206)
        at org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:166)
        at org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2332)
        at org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1555)
        at org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:1183)
        at org.apache.ignite.internal.managers.communication.GridIoManager.access$4200(GridIoManager.java:126)
        at org.apache.ignite.internal.managers.communication.GridIoManager$9.run(GridIoManager.java:1090)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: org.h2.jdbc.JdbcSQLException: Шестнадцатиричная строка содержит нечетное количество символов: "100"
Hexadecimal string with odd number of characters: "100"; SQL statement:
SELECT
__Z0._VAL __C0_0
FROM "Bookmark".BOOKMARK __Z0
WHERE __Z0.STOCKCOUNT = ?1 [90003-195]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
        at org.h2.message.DbException.get(DbException.java:179)
        at org.h2.message.DbException.get(DbException.java:155)
        at org.h2.util.StringUtils.convertHexToBytes(StringUtils.java:930)
        at org.h2.value.Value.convertTo(Value.java:957)
        at org.h2.expression.Comparison.getValue(Comparison.java:264)
        at org.h2.expression.Expression.getBooleanValue(Expression.java:178)
        at org.h2.command.dml.Select.isConditionMet(Select.java:299)
        at org.h2.command.dml.Select.access$600(Select.java:64)
        at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1455)
        at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
        at org.h2.result.LazyResult.next(LazyResult.java:59)
        at org.h2.command.dml.Select.queryFlat(Select.java:519)
        at org.h2.command.dml.Select.queryWithoutCache(Select.java:625)
        at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
        at org.h2.command.dml.Query.query(Query.java:352)
        at org.h2.command.dml.Query.query(Query.java:333)
        at org.h2.command.CommandContainer.query(CommandContainer.java:113)
        at org.h2.command.Command.executeQuery(Command.java:201)
        at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:111)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:963)


> org.h2.jdbc.JdbcSQLException: Hexadecimal string with odd number of characters
> ------------------------------------------------------------------------------
>
>                 Key: IGNITE-6286
>                 URL: https://issues.apache.org/jira/browse/IGNITE-6286
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 2.1
>            Reporter: Sergey Chernolyas
>            Assignee: Sergey Chernolyas
>
> Incorrect binding of  parameter's value for SQL queries with parameters. 
> The  incorrection leads to exception "org.h2.jdbc.JdbcSQLException: Hexadecimal string with odd number of characters"



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)