UNION command throws ASSERTION FAILED error in DV
Issue
- Individually ran
SQLworks
select <column1> from <table1>
select <column1> from <table2>
- following
SQLalso works
select null as <column1>
union
select <column1> from <table1>
union
select <column1> from <table2>
UNIONcommand throws an errorASSERTION FAILED: expected reference to be not null
select <column1> from <table1>
union
select <column1> from <table2>
server.logentry similar to
ERROR \[org.teiid.PROCESSOR\] (Worker59_QueryProcessorQueue7410) TEIID30019 Unexpected exception for request BtFP6pSobsiE.14: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.7.4.6_2-redhat-1.jar:8.7.4.6_2-redhat-1]
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100) [teiid-common-core-8.7.4.6_2-redhat-1.jar:8.7.4.6_2-redhat-1]
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92) [teiid-common-core-8.7.4.6_2-redhat-1.jar:8.7.4.6_2-redhat-1]
at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:286) [teiid-engine-8.7.4.6_2-redhat-1.jar:8.7.4.6_2-redhat-1]
at org.teiid.dqp.internal.process.TupleSourceCache$CopyOnReadTupleSource.nextTuple(TupleSourceCache.java:103) [teiid-engine-8.7.4.6_2-redhat-1.jar:8.7.4.6_2-redhat-1]
at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.4.6_2-redhat-1.jar:8.7.4.6_2-redhat-1]...
Environment
- Red Hat JBoss Data Virtualization (DV) 6.2.3
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
