Thread: One regression failure with 7.4.1 on Debian 3.0r2

I have one regression failure on 7.4.1, which does not occur with 7.4

adam@bugsdb$ more src/test/regress/regression.diffs
*** ./expected/random.out       Thu Feb 13 05:24:04 2003
--- ./results/random.out        Tue Dec 23 20:19:40 2003
***************
*** 25,31 ****   GROUP BY random HAVING count(random) > 1;  random | count  --------+-------
! (0 rows)  SELECT random FROM RANDOM_TBL   WHERE random NOT BETWEEN 80 AND 120;
--- 25,32 ----   GROUP BY random HAVING count(random) > 1;  random | count  --------+-------
!     103 |     2
! (1 row)  SELECT random FROM RANDOM_TBL   WHERE random NOT BETWEEN 80 AND 120;



adam@bugsdb$ uname -a
Linux bugsdb 2.4.23 #1 SMP Tue Dec 23 12:29:42 GMT 2003 i686 unknown


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Adam Witney <awitney@sghms.ac.uk> writes:
> I have one regression failure on 7.4.1, which does not occur with 7.4
>
> adam@bugsdb$ more src/test/regress/regression.diffs
> *** ./expected/random.out       Thu Feb 13 05:24:04 2003
> --- ./results/random.out        Tue Dec 23 20:19:40 2003
> ***************
> *** 25,31 ****
>     GROUP BY random HAVING count(random) > 1;
>    random | count 
>   --------+-------
> ! (0 rows)
>   
>   SELECT random FROM RANDOM_TBL
>     WHERE random NOT BETWEEN 80 AND 120;
> --- 25,32 ----
>     GROUP BY random HAVING count(random) > 1;
>    random | count 
>   --------+-------
> !     103 |     2
> ! (1 row)
>   
>   SELECT random FROM RANDOM_TBL
>     WHERE random NOT BETWEEN 80 AND 120;

Unless this happens consistently (i.e. if you run the regression tests
20 times, this test fails more than once or twice), don't worry about
it: the 'random' test is mildly non-deterministic.

-Neil

UNSUBSCRIBE

UNSUBSCRIBE