Joining two virtual tables that wrap DV SYS views results in ASSERTION FAILED
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 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.
