Support for Aggregates in WHERE of subqureies with outer reference (code review request only)
A subquery can contain an aggregate in selections, where, group by
and having, if all column references contained in in are outer references.
From IWD 9075-2:201?(E), draft standard, 2011-12-21
Section 7.8 WHERE. Syntax rule (SR) 1: WHERE
Section 7.10 HAVING. SR 3
10.9.6 Conformance rules. section 77
1) If a directly contained in the
is a , then the shall be
contained in a or
This change doesn't address all valid usages of aggregates in subqueries. There are some failures
related to binding aggregates, pushing filter to wrong node, and in executor. These will be
addressed on an on going basis. As more cases are coverred revelant unit tests will be enabled.
Support for Aggregates in WHERE of subqureies with outer reference (code review request only) A subquery can contain an aggregate in selections, where, group by and having, if all column references contained in in are outer references. From IWD 9075-2:201?(E), draft standard, 2011-12-21 Section 7.8 WHERE. Syntax rule (SR) 1: WHERE Section 7.10 HAVING. SR 3 10.9.6 Conformance rules. section 77 1) If a directly contained in the
is a , then the shall be
contained in a or
This change doesn't address all valid usages of aggregates in subqueries. There are some failures related to binding aggregates, pushing filter to wrong node, and in executor. These will be addressed on an on going basis. As more cases are coverred revelant unit tests will be enabled.