Re: NIST Test Suite - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: NIST Test Suite
Date
Msg-id 422FF8B1.1060302@familyhealth.com.au
Whole thread Raw
In response to Re: NIST Test Suite  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: NIST Test Suite
List pgsql-hackers
> 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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: NIST Test Suite
Next
From: Tom Lane
Date:
Subject: Re: NIST Test Suite