Re: [HACKERS] regression tests

On Sun, 1 Feb 1998, Bruce Momjian wrote:

> Has anyone tested the regression tests recently. Many problems, I
> maybe think the ORDER BY is broken, as a Unixware person reported.
> Can't beta release with this problem. Is it the new psort() NULL
> handling, or something else?

I just got a chance to do it...the select_distinct test fails
miserably over here on:

QUERY: SELECT DISTINCT two, string4, ten
FROM temp
ORDER BY two using <, string4 using <, ten using <;

with:

two|string4|ten
---+-------+---
0|AAAAxx | 0
0|HHHHxx | 0
0|OOOOxx | 0
0|VVVVxx | 0
+ 0|OOOOxx | 0
+ 0|HHHHxx | 0
+ 0|AAAAxx | 0
+ 0|OOOOxx | 0
+ 0|HHHHxx | 0
+ 0|OOOOxx | 0
+ 0|HHHHxx | 0
+ 0|OOOOxx | 0
+ 0|HHHHxx | 0
+ 0|VVVVxx | 0
+ 0|HHHHxx | 0
+ 0|AAAAxx | 0
<etc,etc>

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org