Horton

Re: [HACKERS] regression tests

Marc G. Fournier <scrappy@hub.org>

View thread
From: The Hermit Hacker <scrappy@hub.org>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: PostgreSQL-development <hackers@postgreSQL.org>
Date: 1998-02-01T11:37:03Z
Lists: pgsql-hackers 
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@hub.org           secondary: scrappy@{freebsd|postgresql}.org