ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Evdokimov (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (IGNITE-540) Sql param substitution does not work in a case
Date Mon, 06 Apr 2015 12:04:12 GMT

     [ https://issues.apache.org/jira/browse/IGNITE-540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sergey Evdokimov closed IGNITE-540.
-----------------------------------

> Sql param substitution does not work in a case
> ----------------------------------------------
>
>                 Key: IGNITE-540
>                 URL: https://issues.apache.org/jira/browse/IGNITE-540
>             Project: Ignite
>          Issue Type: Bug
>    Affects Versions: sprint-2
>            Reporter: Artem Shutak
>            Assignee: Sergey Evdokimov
>             Fix For: sprint-3
>
>         Attachments: ignite-540.patch
>
>
> See IgniteVsH2QueryTest # testParamSubstitution
> Ignite cache failed if try to execute parameterized query with parameter after "select".
> Log:
> [22:08:32,373][INFO ][main][IgniteVsH2QueryTest] >>> Starting test: testParamSubstitution
<<<
> [22:08:32,374][INFO ][test-runner][IgniteVsH2QueryTest] Sql="select ? from "part".Person",
args=[Some arg]
> [22:08:32,383][INFO ][main][IgniteVsH2QueryTest] >>> Stopping test: testParamSubstitution
in 9 ms <<<
> [22:08:32,377][ERROR][main][IgniteVsH2QueryTest] Test failed.
> javax.cache.CacheException: class org.apache.ignite.IgniteException: Unknown data type:
"?" [50004-175]
> 	at org.apache.ignite.internal.processors.cache.IgniteCacheProxy.queryFields(IgniteCacheProxy.java:471)
> 	at org.apache.ignite.internal.processors.query.h2.sql.IgniteVsH2QueryTest.compareQueryRes0(IgniteVsH2QueryTest.java:411)
> 	at org.apache.ignite.internal.processors.query.h2.sql.IgniteVsH2QueryTest.compareQueryRes0(IgniteVsH2QueryTest.java:359)
> 	at org.apache.ignite.internal.processors.query.h2.sql.IgniteVsH2QueryTest.testParamSubstitution(IgniteVsH2QueryTest.java:541)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:606)
> 	at junit.framework.TestCase.runTest(TestCase.java:176)
> 	at org.apache.ignite.testframework.junits.GridAbstractTest.runTestInternal(GridAbstractTest.java:1289)
> 	at org.apache.ignite.testframework.junits.GridAbstractTest.access$000(GridAbstractTest.java:65)
> 	at org.apache.ignite.testframework.junits.GridAbstractTest$2.run(GridAbstractTest.java:1232)
> Caused by: class org.apache.ignite.IgniteException: Unknown data type: "?" [50004-175]
> 	at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:273)
> 	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:698)
> 	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:777)
> 	at org.apache.ignite.internal.processors.query.GridQueryProcessor.queryTwoStep(GridQueryProcessor.java:454)
> 	at org.apache.ignite.internal.processors.cache.IgniteCacheProxy.queryFields(IgniteCacheProxy.java:465)
> 	... 11 more
> Caused by: class org.apache.ignite.IgniteCheckedException: Unknown data type: "?" [50004-175]
> 	at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.createFunctionTable(GridReduceQueryExecutor.java:488)
> 	at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:270)
> 	... 15 more
> Caused by: org.h2.message.DbException: Unknown data type: "?" [50004-175]
> 	at org.h2.message.DbException.get(DbException.java:172)
> 	at org.h2.message.DbException.get(DbException.java:149)
> 	at org.h2.value.DataType.getDataType(DataType.java:720)
> 	at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.generateColumnsFromQuery(GridReduceQueryExecutor.java:445)
> 	at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.createFunctionTable(GridReduceQueryExecutor.java:481)
> 	... 16 more
> Caused by: org.h2.jdbc.JdbcSQLException: Unknown data type: "?" [50004-175]
> 	at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
> 	... 21 more
> javax.cache.CacheException: class org.apache.ignite.IgniteException: Unknown data type:
"?" [50004-175]
> 	at org.apache.ignite.internal.processors.cache.IgniteCacheProxy.queryFields(IgniteCacheProxy.java:471)
> 	at org.apache.ignite.internal.processors.query.h2.sql.IgniteVsH2QueryTest.compareQueryRes0(IgniteVsH2QueryTest.java:411)
> 	at org.apache.ignite.internal.processors.query.h2.sql.IgniteVsH2QueryTest.compareQueryRes0(IgniteVsH2QueryTest.java:359)
> 	at org.apache.ignite.internal.processors.query.h2.sql.IgniteVsH2QueryTest.testParamSubstitution(IgniteVsH2QueryTest.java:541)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at org.apache.ignite.testframework.junits.GridAbstractTest.runTestInternal(GridAbstractTest.java:1289)
> 	at org.apache.ignite.testframework.junits.GridAbstractTest.access$000(GridAbstractTest.java:65)
> 	at org.apache.ignite.testframework.junits.GridAbstractTest$2.run(GridAbstractTest.java:1232)
> Caused by: class org.apache.ignite.IgniteException: Unknown data type: "?" [50004-175]
> 	at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:273)
> 	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:698)
> 	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:777)
> 	at org.apache.ignite.internal.processors.query.GridQueryProcessor.queryTwoStep(GridQueryProcessor.java:454)
> 	at org.apache.ignite.internal.processors.cache.IgniteCacheProxy.queryFields(IgniteCacheProxy.java:465)
> 	... 11 more
> Caused by: class org.apache.ignite.IgniteCheckedException: Unknown data type: "?" [50004-175]
> 	at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.createFunctionTable(GridReduceQueryExecutor.java:488)
> 	at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:270)
> 	... 15 more
> Caused by: org.h2.message.DbException: Unknown data type: "?" [50004-175]
> 	at org.h2.message.DbException.get(DbException.java:172)
> 	at org.h2.message.DbException.get(DbException.java:149)
> 	at org.h2.value.DataType.getDataType(DataType.java:720)
> 	at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.generateColumnsFromQuery(GridReduceQueryExecutor.java:445)
> 	at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.createFunctionTable(GridReduceQueryExecutor.java:481)
> 	... 16 more
> Caused by: org.h2.jdbc.JdbcSQLException: Unknown data type: "?" [50004-175]
> 	at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
> 	... 21 more



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message