[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1166) Receiving ASSERTION FAILED: expected reference to be not null from SQL query with sub-select

Receiving ASSERTION FAILED: expected reference to be not null from SQL query with sub-select -------------------------------------------------------------------------------------------- Key: TEIID-1166 URL: https://jira.jboss.org/browse/TEIID-1166 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Environment: Fedora 12, Teiid 7 Final Reporter: Paul Nittel Assignee: Steve Hawkins Fix For: 7.1 Attachments: RecursiveText_MPS.zip, serverLogSnippetEmployees.txt Using a model built in Designer, and a text file-based data source, I queried SELECT * FROM "EmployeeData"."Employee" WHERE annualSalary < (SELECT AVG(annualSalary) FROM "EmployeeData"."Employee") using SQuirreL and received this exception: 2010-07-23 13:33:48,169 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-44_QueryProcessorQueue141) [Ljava.lang.Object;@913388 java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null at org.teiid.core.util.Assertion.failed(Assertion.java:76) at org.teiid.core.util.Assertion.isNotNull(Assertion.java:307) at org.teiid.core.util.Assertion.isNotNull(Assertion.java:299) at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:347) at org.teiid.query.processor.relational.TextTableNode.initialize(TextTableNode.java:115) at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:74) at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:79) at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:79) at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:79) at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:79) at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:69) at org.teiid.query.processor.QueryProcessor.<init>(QueryProcessor.java:86) at org.teiid.dqp.internal.process.Request.createProcessor(Request.java:356) at org.teiid.dqp.internal.process.Request.processRequest(Request.java:452) at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:346) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:167) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.java:190) at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.java:187) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:176) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:187) at org.teiid.dqp.internal.process.StatsCapturingWorkManager$WorkWrapper.run(StatsCapturingWorkManager.java:102) at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:205) at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Each part of the query works independently. I will attach more of the log file and the Model Project Set.