One regression failure with 7.4.1 on Debian 3.0r2
Started by Adam Witneyabout 22 years ago4 messages
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.
Re: One regression failure with 7.4.1 on Debian 3.0r2
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
