Sergey Korotkov created IGNITE-24800:
----------------------------------------
Summary: NPE in H2 engine for EXPLAIN SQL query if performance
statistics is enabled
Key: IGNITE-24800
URL: https://issues.apache.org/jira/browse/IGNITE-24800
Project: Ignite
Issue Type: Bug
Reporter: Sergey Korotkov
Attachments: PerformanceStatisticsExplainQueryTest.java
After the IGNITE-24385 if performance statistics is enabled the EXPLAIN SQL
query
fails with the NPE exception.
Reproducer is attached.
Such an SQL
{code:sql}
create table item(id integer, data integer, primary key(id));
explain plan for select * from item;
{code}
generates the following exception
{noformat}
java.lang.NullPointerException: null
at
org.apache.ignite.internal.processors.query.h2.H2QueryInfo.planWithoutScanCount(H2QueryInfo.java:238)
~[classes/:?]
at
org.apache.ignite.internal.processors.query.h2.H2QueryInfo.plan(H2QueryInfo.java:125)
~[classes/:?]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:477)
[classes/:?]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:283)
[classes/:?]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.onMessage(IgniteH2Indexing.java:1681)
[classes/:?]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:154)
[classes/:?]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:149)
[classes/:?]
at
org.apache.ignite.internal.util.lang.IgniteInClosure2X.apply(IgniteInClosure2X.java:38)
[classes/:?]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.send(IgniteH2Indexing.java:1806)
[classes/:?]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1212)
[classes/:?]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:448)
[classes/:?]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$5.iterator(IgniteH2Indexing.java:1460)
[classes/:?]
at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.iter(QueryCursorImpl.java:102)
[classes/:?]
at
org.apache.ignite.internal.processors.query.h2.RegisteredQueryCursor.iter(RegisteredQueryCursor.java:91)
[classes/:?]
at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.getAll(QueryCursorImpl.java:124)
[classes/:?]
at
org.apache.ignite.internal.processors.performancestatistics.PerformanceStatisticsExplainQueryTest.sql(PerformanceStatisticsExplainQueryTest.java:38)
[test-classes/:?]
at
org.apache.ignite.internal.processors.performancestatistics.PerformanceStatisticsExplainQueryTest.testSqlFieldsQuery(PerformanceStatisticsExplainQueryTest.java:34)
[test-classes/:?]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:?]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:?]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?]
at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
[junit-4.12.jar:4.12]
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
[junit-4.12.jar:4.12]
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
[junit-4.12.jar:4.12]
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
[junit-4.12.jar:4.12]
at
org.apache.ignite.testframework.junits.GridAbstractTest$6.run(GridAbstractTest.java:2508)
[test-classes/:?]
at java.base/java.lang.Thread.run(Thread.java:829) [?:?]
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
