Thread

1. One regression failure with 7.4.1 on Debian 3.0r2

   awitney@sghms.ac.uk — 2003-12-23T20:24:57Z

   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.
   
   
   

2. Re: One regression failure with 7.4.1 on Debian 3.0r2

   Neil Conway <neilc@samurai.com> — 2004-01-05T14:17:08Z

   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
   
   
   

3. UNSUBSCRIBE

   Ben Clewett <b.clewett@roadrunner.uk.com> — 2004-01-05T17:15:06Z

   UNSUBSCRIBE
   
   

4. UNSUBSCRIBE

   Steven Vajdic <svajdic@asc.corp.mot.com> — 2004-01-05T22:46:22Z

   UNSUBSCRIBE