[teiid-issues] [JBoss JIRA] (TEIID-2220) Invalid aggregate pushing

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-2220:
-------------------------------------

             Summary: Invalid aggregate pushing
                 Key: TEIID-2220
                 URL: https://issues.jboss.org/browse/TEIID-2220
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: 7.7
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 8.2


When a grouping is performed over a 3 way or higher join and aggregation appears to be eligible to be pushed to a leaf join, but a higher level join contains equi-join criteria where the side in the path of push aggregate target uses a join expression that spans a table not in the aggregate target, then an exception will be thrown during processing that the outside expression value cannot be found.

For example:

TEIID30328 Unable to evaluate t2.e3: No value was available
	at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:430)
	at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:617)
	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1021)
	at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:622)
	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1021)
	at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:622)
	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:592)
	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:270)
	at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:210)
	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:199)
	at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:312)



--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira