[teiid-issues] [JBoss JIRA] Closed: (TEIID-568) Appears that join criteria not always propagated to dependent side of join.

[Steven Hawkins (JIRA)]

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

Steven Hawkins closed TEIID-568.
--------------------------------



> Appears that join criteria not always propagated to dependent side of join.
> ---------------------------------------------------------------------------
>
>                 Key: TEIID-568
>                 URL: https://jira.jboss.org/jira/browse/TEIID-568
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 6.0.0
>         Environment: Teiid 6.0.0 (Apr 27).  Running in JBoss AS 4.2.3 but also happens in Designer during Preview or SQL Execution.  VDB and model project set attached.  
>            Reporter: Ken Johnson
>            Assignee: Steven Hawkins
>             Fix For: 6.1.0
>
>         Attachments: CapitalCity.zip, FinancialStarSchema_20090506_Teiid.zip, FinancialsVDB.vdb
>
>
> Getting exception in Teiid that suggests join criteria is not being propagated to the dependent side of the join in this case.  This same query and model set/VDB work correctly in MMX 5.5.3 but error in Teiid.  All data sources, drivers are the same, running on the same physical system.
> The problematic model is ReportingSchema.xmiin VirtualQueryLayer.  All three views therein have the problem.  The exception below is generated from this query:
> select * from AllData_Flattened
> Exception:
> May 08, 2009 11:21:09.246 [QueryProcessorQueue0|0] ERROR <DQP|0> ############# PW EXITING on 00000000-0000-0001-0000-000000000001.0 - error occurred ###########
> [MetaMatrixComponentException] ERR.015.006.0033: Unable to evaluate Products_DS.products.productdata.ProductID: No value was available
> 	at com.metamatrix.query.eval.Evaluator.internalEvaluate(Evaluator.java:500)
> 	at com.metamatrix.query.eval.Evaluator.evaluate(Evaluator.java:475)
> 	at com.metamatrix.query.eval.Evaluator.evaluate(Evaluator.java:195)
> 	at com.metamatrix.query.eval.Evaluator.evaluateTVL(Evaluator.java:109)
> 	at com.metamatrix.query.eval.Evaluator.evaluate(Evaluator.java:98)
> 	at com.metamatrix.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:290)
> 	at com.metamatrix.query.processor.relational.MergeJoinStrategy.nextTuple(MergeJoinStrategy.java:245)
> 	at com.metamatrix.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:183)
> 	at com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:243)
> 	at com.metamatrix.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:173)
> 	at com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:243)
> 	at com.metamatrix.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:109)
> 	at com.metamatrix.query.processor.QueryProcessor.process(QueryProcessor.java:151)
> 	at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:269)
> 	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:213)
> 	at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
> 	at java.lang.Thread.run(Thread.java:619)

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