"Dann Corbit" <[EMAIL PROTECTED]> writes:
>> --- and no I have zero confidence that passing the regression
>> tests proves anything, because all those prior bugs passed
>> the regression tests.
> Then why didn't those bugs get added to the regression?
Because there wasn't any reasonable way to make them reproducible.
The set of things we can test in the regression tests is only a small
fraction of the interesting properties of Postgres. This is
unfortunate but ranting about "standard practice" doesn't change it.
> I seem to recall that someone was porting the NIST suite to PostgreSQL.
> What ever happened to that effort?
It was done and we fixed a couple of bugs based on it (the one I can
think of offhand had to do with semantics of aggregate functions in
sub-selects). I don't think there's anything more to be learned there.
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
