"ASSERTION FAILED: expected reference to be not null" when using group by in JBoss EDS SQL
Issue
NullPointerException
from query planningjava.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
when running the following SQL
SELECT b.ACCOUNT FROM (SELECT bb.ACCOUNT FROM Entity_Model.Ledger.FinancialTradeItems bb, Entity_Model.Ledger.Accounts aa) b, ( SELECT 'BREAKME')c GROUP BY b.ACCOUNT
- similar errors to below in the
server.log
java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
at org.teiid.core.util.Assertion.failed(Assertion.java:73)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:366)
at org.teiid.query.processor.relational.JoinNode.initialize(JoinNode.java:129)
at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:75).......
java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
at org.teiid.core.util.Assertion.failed(Assertion.java:73)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:290)
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:64)
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69)
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:85)
at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48)
at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:248)
at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:185)
at org.teiid.query.processor.relational.SourceState.sort(SourceState.java:307)
at org.teiid.query.processor.relational.MergeJoinStrategy.loadRight(MergeJoinStrategy.java:348)
at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadRight(EnhancedSortMerge
Environment
- JBoss Enterprise Data Services (EDS) 5.1, 5.3
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.