2:24 p.m.
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