Intermittent Regression test failure in create_misc

Robert Hentosh (hentosh@io.com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Intermittent Regression test failure in create_misc

Long Description
After fetching the latest CVS yesterday. I ran the regression test several times in a row. Actually around 10x... in
thattime it failed two times the same way.  I noticed that locking code was changed in CVS after the tag of BETA3 so I
fetchedfrom CVS the REL7_1_BETA3 tag.  This one took around 12 tries but finally failed the same way. 

I am running on a freshly installed OpenBSD 2.8 on a Petium III with 128M real mem and 256M swap. I didn't make any
modificationsto ulimits or other system settings other than adding bison and enabling soft updates (The test failed
beforeand after enabling soft updates). 

Postgresql was compiled with ./configure --enable-syslog after modifying "#define BLCKSZ 16384" in
src/include/config.h.in

Here is the begining of regression.diffs The errors that follow the first one seem to all be related to the fact that
thisone failed and the that onek and onek2 do not exist. 

----------------------------
*** ./expected/create_misc.out  Sat Feb 24 23:14:39 2001
--- ./results/create_misc.out   Mon Feb 26 15:37:15 2001
***************
*** 6,11 ****
--- 6,12 ----
  --
  INSERT INTO tenk2 VALUES (tenk1.*);
  SELECT * INTO TABLE onek2 FROM onek;
+ ERROR:  Relation 'onek' does not exist
  INSERT INTO fast_emp4000 VALUES (slow_emp4000.*);
  SELECT *
     INTO TABLE Bprime

======================================================================

*** ./expected/select_into.out  Sat Feb 24 23:14:48 2001
--- ./results/select_into.out   Mon Feb 26 15:37:48 2001
***************
*** 10,13 ****
--- 10,15 ----
     INTO TABLE tmp1
     FROM onek2
     WHERE onek2.unique1 < 2;
+ ERROR:  Relation 'onek2' does not exist
  DROP TABLE tmp1;
+ ERROR:  table "tmp1" does not exist

======================================================================

*** ./expected/misc.out Sat Feb 24 23:31:36 2001
--- ./results/misc.out  Mon Feb 26 15:38:00 2001
***************
*** 30,35 ****
--- 30,36 ----
     SET stringu1 = reverse_name(onek2.stringu1)
     WHERE onek2.stringu1 = 'JCAAAA' and
          onek2.stringu1 = tmp.stringu1;
+ ERROR:  Relation 'onek2' does not exist
----------------------------


Sample Code


No file was uploaded with this report