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.
I was just chatting with Neil C on IRC and he mentioned that back when they were using it at RedHat, PostgreSQL didn't have schemas so most stuff failed. Was just wondering if that's true and we need to re-run them or something.
Chris
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
