UNION command throws ASSERTION FAILED error in DV

Solution In Progress - Updated -

Issue

  • Individually ran SQL works
select <column1> from <table1>
select <column1> from <table2>
  • following SQL also works
select null as <column1>
union
select <column1> from <table1>
union
select <column1> from <table2>
  • UNION command throws an error ASSERTION FAILED: expected reference to be not null
select <column1> from <table1>
union
select <column1> from <table2>
  • server.log entry 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.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.