Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Are we able to run more NIST tests now?
> http://www.itl.nist.gov/div897/ctg/sql_form.htm
I thought we'd extracted all the interesting juice from the NIST tests
a couple years ago. Specifically I recall this fix came out of NIST
testing done by Red Hat:
2003-06-06 11:04 tgl
Implement outer-level
aggregates to conform to the SQL spec, with extensions to support
our historical behavior. An aggregate belongs to the closest query
level of any of the variables in its argument, or the current query
level if there are no variables (e.g., COUNT(*)). The
implementation involves adding an agglevelsup field to Aggref, and
treating outer aggregates like outer variables at planning time.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
