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

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

reproduced for BigDecimal type.

[2017-09-22 
16:02:53,609][ERROR][query-#644%query.IgniteSqlParameterizedQueryTest0%][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:972)
        at 
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1031)
        at 
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1010)
        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: Шестнадцатиричная строка содержит 
нешестнадцатиричные символы: "1000000000000000.001"
Hexadecimal string contains non-hex character: "1000000000000000.001"; SQL 
statement:
SELECT
__Z0._VAL __C0_0
FROM "Bookmark".BOOKMARK __Z0
WHERE __Z0.SITEWEIGHT = ?1 [90004-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:946)
        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:965)

> 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)

Reply via email to