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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content