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