Yes, this does randomly fail (WHERE random NOT BETWEEN 80 AND 120).
(That is OK.)
I modified the code so the failures are much rarer in 8.0.
---------------------------------------------------------------------------
Ed L. wrote:
> On Tuesday June 21 2005 11:22 am, Ed L. wrote:
> > Fyi, I got this regression diff on my IBM T41 laptop running
> > new install of Fedora Core 4... no idea why...
> >
> > PostgreSQL 7.4.8 on i686-pc-linux-gnu, compiled by GCC gcc
> > (GCC) 4.0.0 20050519 (Red Hat 4.0.0-8)
> >
> >
> > /pgsql/builds/postgresql-7.4.8/src/test/regress
> > % cat ./regression.diffs
> > *** ./expected/random.out Wed Feb 12 22:24:04 2003
> > --- ./results/random.out Tue Jun 21 11:16:11 2005
> > ***************
> > *** 31,35 ****
> > WHERE random NOT BETWEEN 80 AND 120;
> > random
> > --------
> > ! (0 rows)
> >
> > --- 31,36 ----
> > WHERE random NOT BETWEEN 80 AND 120;
> > random
> > --------
> > ! 79
> > ! (1 row)
>
> This seems to be an intermittent regression failure. A second
> run just now with same build passed all tests.
>
> Ed
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073