[IGNITE-23214] Can not use DURATION parameters in select queries

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: ignite-3
• Assignee: Iurii Gerzhedovich
• Reporter: Igor Sapego
• Created: 16/Sep/24 23:17
• Updated: 24/Oct/24 09:20
• Resolved: 24/Oct/24 09:20

Description

An SQL query to reproduce:

SELECT ?

With a DURATION type parameter.

Exception:

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

Issue Links

• links to: GitHub Pull Request #4613