Joining two virtual tables that wrap DV SYS views results in ASSERTION FAILED

Solution Verified - Updated -

Issue

  • When joining together 2 virtual tables that virtualize Teiid SYS tables (Columns, Tables, and Properties), although the data comes back from each half of those joins, seperately, as not null, the query errors with ASSERTION FAILED exception:
15:28:55,188 ERROR [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue45) kcayzLVMEpN7 TEIID30019 Unexpected exception for request kcayzLVMEpN7.0: 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.9.0.Final.jar:8.9.0.Final]
    at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100) [teiid-common-core-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92) [teiid-common-core-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:365) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.tempdata.TempTable$QueryTupleSource.<init>(TempTable.java:178) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.tempdata.TempTable$QueryTupleSource.<init>(TempTable.java:167) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.tempdata.TempTable.createTupleSource(TempTable.java:507) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.tempdata.TempTable.createTupleSource(TempTable.java:499) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.tempdata.TempTableDataManager$5.createTupleSource(TempTableDataManager.java:663) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.1

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