[
https://issues.apache.org/jira/browse/IGNITE-24800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937280#comment-17937280
]
Oleg Valuyskiy commented on IGNITE-24800:
-----------------------------------------
[~alex_pl] Thank you for the review!
> 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
> Assignee: Oleg Valuyskiy
> Priority: Major
> Labels: ise
> Fix For: 2.18
>
> Attachments: PerformanceStatisticsExplainQueryTest.java
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> 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)
