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)
