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

[Paul Nittel (JIRA)]

     [ https://jira.jboss.org/browse/TEIID-1166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul Nittel updated TEIID-1166:
-------------------------------

    Attachment: serverLogSnippetEmployees.txt
                RecursiveText_MPS.zip


> 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