Re: NIST Test Suite

Christopher Kings-Lynne <chriskl@familyhealth.com.au> 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-levelaggregates to conform to the SQL spec, with extensions to supportour historical behavior.  An
aggregatebelongs to the closest querylevel of any of the variables in its argument, or the current querylevel if there
areno variables (e.g., COUNT(*)).  Theimplementation involves adding an agglevelsup field to Aggref, andtreating outer
aggregateslike outer variables at planning time.
 
        regards, tom lane