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

[Paul Nittel (JIRA)]

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
         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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira