You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Igor Sapego (Jira)" <ji...@apache.org> on 2024/09/16 23:18:00 UTC
[jira] [Created] (IGNITE-23214) Can not use DURATION parameters in select queries
Igor Sapego created IGNITE-23214:
------------------------------------
Summary: Can not use DURATION parameters in select queries
Key: IGNITE-23214
URL: https://issues.apache.org/jira/browse/IGNITE-23214
Project: Ignite
Issue Type: Bug
Components: sql
Reporter: Igor Sapego
An SQL query to reproduce:
{code:sql}
SELECT ?
{code}
With a DURATION type parameter.
Exception:
{noformat}
Error processing client request [connectionId=375, id=0, op=50, remoteAddress=/192.168.1.133:61204]:org.apache.ignite.sql.SqlException: IGN-CMN-65535 TraceId:2a5ea9c9-e5e2-4edb-8cd7-d943cbb266d9
java.util.concurrent.CompletionException: org.apache.ignite.sql.SqlException: IGN-CMN-65535 TraceId:2a5ea9c9-e5e2-4edb-8cd7-d943cbb266d9
at org.apache.ignite.client.handler.requests.sql.ClientSqlExecuteRequest.lambda$executeAsync$4(ClientSqlExecuteRequest.java:184) ~[ignite-client-handler-3.0.0-SNAPSHOT.jar:?]
at java.base/java.util.concurrent.CompletableFuture.uniExceptionally(CompletableFuture.java:986) [?:?]
at java.base/java.util.concurrent.CompletableFuture.uniExceptionallyStage(CompletableFuture.java:1004) [?:?]
at java.base/java.util.concurrent.CompletableFuture.exceptionally(CompletableFuture.java:2309) [?:?]
at org.apache.ignite.client.handler.requests.sql.ClientSqlExecuteRequest.executeAsync(ClientSqlExecuteRequest.java:181) ~[ignite-client-handler-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.client.handler.requests.sql.ClientSqlExecuteRequest.process(ClientSqlExecuteRequest.java:89) ~[ignite-client-handler-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.client.handler.ClientInboundMessageHandler.processOperation(ClientInboundMessageHandler.java:797) ~[ignite-client-handler-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.client.handler.ClientInboundMessageHandler.processOperation(ClientInboundMessageHandler.java:605) [ignite-client-handler-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.client.handler.ClientInboundMessageHandler.channelRead(ClientInboundMessageHandler.java:330) [ignite-client-handler-3.0.0-SNAPSHOT.jar:?]
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346) [netty-codec-4.1.113.Final.jar:4.1.113.Final]
at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:318) [netty-codec-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:289) [netty-handler-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1357) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:868) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562) [netty-transport-4.1.113.Final.jar:4.1.113.Final]
at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997) [netty-common-4.1.113.Final.jar:4.1.113.Final]
at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) [netty-common-4.1.113.Final.jar:4.1.113.Final]
at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [netty-common-4.1.113.Final.jar:4.1.113.Final]
at java.base/java.lang.Thread.run(Thread.java:834) [?:?]
Caused by: org.apache.ignite.sql.SqlException
at org.apache.ignite.internal.lang.SqlExceptionMapperUtil.mapToPublicSqlException(SqlExceptionMapperUtil.java:61) ~[ignite-sql-engine-3.0.0-SNAPSHOT.jar:?]
... 34 more
Caused by: org.apache.ignite.lang.IgniteException
at org.apache.ignite.internal.lang.IgniteExceptionMapperUtil.lambda$mapToPublicException$2(IgniteExceptionMapperUtil.java:88) ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.internal.lang.IgniteExceptionMapperUtil.mapCheckingResultIsPublic(IgniteExceptionMapperUtil.java:141) ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.internal.lang.IgniteExceptionMapperUtil.mapToPublicException(IgniteExceptionMapperUtil.java:137) ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.internal.lang.IgniteExceptionMapperUtil.mapToPublicException(IgniteExceptionMapperUtil.java:88) ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.internal.lang.SqlExceptionMapperUtil.mapToPublicSqlException(SqlExceptionMapperUtil.java:51) ~[ignite-sql-engine-3.0.0-SNAPSHOT.jar:?]
... 34 more
Caused by: java.lang.NullPointerException
at org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.tryCreateCacheKeyFromParameterValues(PrepareServiceImpl.java:674) ~[ignite-sql-engine-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.getPlanIfParameterHaveValues(PrepareServiceImpl.java:630) ~[ignite-sql-engine-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.prepareQuery(PrepareServiceImpl.java:339) ~[ignite-sql-engine-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.prepareAsync0(PrepareServiceImpl.java:264) ~[ignite-sql-engine-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.prepareAsync(PrepareServiceImpl.java:248) ~[ignite-sql-engine-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.internal.sql.engine.SqlQueryProcessor.lambda$executeParsedStatement$14(SqlQueryProcessor.java:603) ~[ignite-sql-engine-3.0.0-SNAPSHOT.jar:?]
at java.base/java.util.concurrent.CompletableFuture.uniComposeStage(CompletableFuture.java:1106) ~[?:?]
at java.base/java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.java:2237) ~[?:?]
at org.apache.ignite.internal.sql.engine.SqlQueryProcessor.executeParsedStatement(SqlQueryProcessor.java:603) ~[ignite-sql-engine-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.internal.sql.engine.SqlQueryProcessor.lambda$querySingle$8(SqlQueryProcessor.java:529) ~[ignite-sql-engine-3.0.0-SNAPSHOT.jar:?]
at java.base/java.util.concurrent.CompletableFuture.uniComposeStage(CompletableFuture.java:1106) ~[?:?]
at java.base/java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.java:2237) ~[?:?]
at org.apache.ignite.internal.sql.engine.SqlQueryProcessor.querySingle(SqlQueryProcessor.java:512) ~[ignite-sql-engine-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.internal.sql.engine.SqlQueryProcessor.queryAsync(SqlQueryProcessor.java:433) ~[ignite-sql-engine-3.0.0-SNAPSHOT.jar:?]
at org.apache.ignite.client.handler.requests.sql.ClientSqlExecuteRequest.executeAsync(ClientSqlExecuteRequest.java:169) ~[ignite-client-handler-3.0.0-SNAPSHOT.jar:?]
... 29 more
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)