Further updated regression output for FreeBSD

scrappy · scrappy · commit bc58c5867df7 · 1998-02-28T21:28:30.000Z
diff --git a/src/test/regress/regression.FreeBSD b/src/test/regress/regression.FreeBSD
@@ -1,6 +1,6 @@
 
 *** expected/float8.out	Fri Feb 20 00:08:58 1998
---- results/float8.out	Thu Feb 26 23:22:19 1998
+--- results/float8.out	Sat Feb 28 16:53:53 1998
 ***************
 *** 9,17 ****
   QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
@@ -288,7 +288,7 @@
 ----------------------
 
 *** expected/numerology.out	Fri Feb 20 00:09:37 1998
---- results/numerology.out	Thu Feb 26 23:22:20 1998
+--- results/numerology.out	Sat Feb 28 16:53:53 1998
 ***************
 *** 36,44 ****
       |     0
@@ -335,7 +335,7 @@
 ----------------------
 
 *** expected/geometry.out	Fri Feb 20 00:09:04 1998
---- results/geometry.out	Thu Feb 26 23:22:24 1998
+--- results/geometry.out	Sat Feb 28 16:53:57 1998
 ***************
 *** 100,106 ****
         |(5.1,34.5)|[(1,2),(3,4)]                |(3,4)                               
@@ -578,7 +578,7 @@
 ----------------------
 
 *** expected/tinterval.out	Fri Feb 20 00:12:49 1998
---- results/tinterval.out	Thu Feb 26 23:22:28 1998
+--- results/tinterval.out	Sat Feb 28 16:54:00 1998
 ***************
 *** 110,129 ****
      ORDER BY interval1, interval2;
@@ -625,80 +625,16 @@
 
 ----------------------
 
-*** expected/constraints.out	Thu Feb 26 23:21:56 1998
---- results/constraints.out	Thu Feb 26 23:22:37 1998
-***************
-*** 278,298 ****
-  QUERY: CREATE TABLE UNIQUE_TBL (i int, t text,
-  	UNIQUE(i,t));
-  NOTICE:  CREATE TABLE/UNIQUE will create implicit index unique_tbl_i_key for table unique_tbl
-  QUERY: INSERT INTO UNIQUE_TBL VALUES (1, 'one');
-  QUERY: INSERT INTO UNIQUE_TBL VALUES (2, 'two');
-  QUERY: INSERT INTO UNIQUE_TBL VALUES (1, 'three');
-  QUERY: INSERT INTO UNIQUE_TBL VALUES (1, 'one');
-! ERROR:  Cannot insert a duplicate key into a unique index
-  QUERY: INSERT INTO UNIQUE_TBL VALUES (5, 'one');
-  QUERY: INSERT INTO UNIQUE_TBL (t) VALUES ('six');
-  QUERY: SELECT '' AS five, * FROM UNIQUE_TBL;
-! five|i|t    
-! ----+-+-----
-!     |1|one  
-!     |2|two  
-!     |1|three
-!     |5|one  
-!     | |six  
-! (5 rows)
-! 
-  QUERY: DROP TABLE UNIQUE_TBL;
---- 278,298 ----
-  QUERY: CREATE TABLE UNIQUE_TBL (i int, t text,
-  	UNIQUE(i,t));
-  NOTICE:  CREATE TABLE/UNIQUE will create implicit index unique_tbl_i_key for table unique_tbl
-+ PQexec() -- Request was sent to backend, but backend closed the channel before responding.
-+ 	This probably means the backend terminated abnormally before or while processing the request.
-  QUERY: INSERT INTO UNIQUE_TBL VALUES (1, 'one');
-+ PQexec() -- There is no connection to the backend.
-  QUERY: INSERT INTO UNIQUE_TBL VALUES (2, 'two');
-+ PQexec() -- There is no connection to the backend.
-  QUERY: INSERT INTO UNIQUE_TBL VALUES (1, 'three');
-+ PQexec() -- There is no connection to the backend.
-  QUERY: INSERT INTO UNIQUE_TBL VALUES (1, 'one');
-! PQexec() -- There is no connection to the backend.
-  QUERY: INSERT INTO UNIQUE_TBL VALUES (5, 'one');
-+ PQexec() -- There is no connection to the backend.
-  QUERY: INSERT INTO UNIQUE_TBL (t) VALUES ('six');
-+ PQexec() -- There is no connection to the backend.
-  QUERY: SELECT '' AS five, * FROM UNIQUE_TBL;
-! PQexec() -- There is no connection to the backend.
-  QUERY: DROP TABLE UNIQUE_TBL;
-+ PQexec() -- There is no connection to the backend.
-
-----------------------
-
 *** expected/create_index.out	Fri Feb 20 00:08:41 1998
---- results/create_index.out	Thu Feb 26 23:23:20 1998
+--- results/create_index.out	Sat Feb 28 16:55:10 1998
 ***************
-*** 1,22 ****
---- 1,43 ----
-  QUERY: CREATE INDEX onek_unique1 ON onek USING btree(unique1 int4_ops);
-  QUERY: CREATE INDEX onek_unique2 ON onek USING btree(unique2 int4_ops);
-  QUERY: CREATE INDEX onek_hundred ON onek USING btree(hundred int4_ops);
-+ PQexec() -- Request was sent to backend, but backend closed the channel before responding.
-+ 	This probably means the backend terminated abnormally before or while processing the request.
-  QUERY: CREATE INDEX onek_stringu1 ON onek USING btree(stringu1 char16_ops);
-+ PQexec() -- There is no connection to the backend.
-  QUERY: CREATE INDEX tenk1_unique1 ON tenk1 USING btree(unique1 int4_ops);
-+ PQexec() -- There is no connection to the backend.
-  QUERY: CREATE INDEX tenk1_unique2 ON tenk1 USING btree(unique2 int4_ops);
-+ PQexec() -- There is no connection to the backend.
-  QUERY: CREATE INDEX tenk1_hundred ON tenk1 USING btree(hundred int4_ops);
-+ PQexec() -- There is no connection to the backend.
+*** 8,22 ****
+--- 8,36 ----
   QUERY: CREATE INDEX tenk2_unique1 ON tenk2 USING btree(unique1 int4_ops);
-+ PQexec() -- There is no connection to the backend.
   QUERY: CREATE INDEX tenk2_unique2 ON tenk2 USING btree(unique2 int4_ops);
-+ PQexec() -- There is no connection to the backend.
   QUERY: CREATE INDEX tenk2_hundred ON tenk2 USING btree(hundred int4_ops);
-+ PQexec() -- There is no connection to the backend.
++ PQexec() -- Request was sent to backend, but backend closed the channel before responding.
++ 	This probably means the backend terminated abnormally before or while processing the request.
   QUERY: CREATE INDEX rix ON road USING btree (name text_ops);
 + PQexec() -- There is no connection to the backend.
   QUERY: CREATE INDEX iix ON ihighway USING btree (name text_ops);
@@ -727,7 +663,7 @@
 ----------------------
 
 *** expected/sanity_check.out	Fri Feb 20 00:10:05 1998
---- results/sanity_check.out	Thu Feb 26 23:23:33 1998
+--- results/sanity_check.out	Sat Feb 28 16:55:27 1998
 ***************
 *** 5,20 ****
      ORDER BY relname;
@@ -752,23 +688,25 @@
   pg_relcheck   |t          
   pg_trigger    |t          
   pg_type       |t          
-! road          |t          
-! shighway      |t          
-! tenk1         |t          
-! tenk2         |t          
+- road          |t          
+- shighway      |t          
+  tenk1         |t          
+  tenk2         |t          
 ! (23 rows)
   
---- 14,18 ----
+--- 14,20 ----
   pg_relcheck   |t          
   pg_trigger    |t          
   pg_type       |t          
-! (9 rows)
+  tenk1         |t          
+  tenk2         |t          
+! (11 rows)
   
 
 ----------------------
 
 *** expected/random.out	Fri Feb 20 00:10:04 1998
---- results/random.out	Thu Feb 26 23:23:38 1998
+--- results/random.out	Sat Feb 28 16:55:32 1998
 ***************
 *** 7,18 ****
   QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
@@ -799,86 +737,3 @@
 
 ----------------------
 
-*** expected/alter_table.out	Fri Feb 20 00:08:33 1998
---- results/alter_table.out	Thu Feb 26 23:24:17 1998
-***************
-*** 88,113 ****
-  QUERY: SELECT unique1 FROM ten_k WHERE unique1 < 20;
-  unique1
-  -------
-!       0
-!       1
-!       2
-!       3
-        4
-!       5
-        6
-!       7
-!       8
-        9
-!      10
-!      11
-!      12
-       13
-!      14
-!      15
-!      16
-!      17
-!      18
-       19
-  (20 rows)
-  
-  QUERY: SELECT unique2 FROM ten_k WHERE unique2 < 20;
---- 88,113 ----
-  QUERY: SELECT unique1 FROM ten_k WHERE unique1 < 20;
-  unique1
-  -------
-!      18
-!      15
-        4
-!       2
-!       1
-        6
-!      14
-        9
-!       8
-!       5
-!       3
-       13
-!      12
-       19
-+      17
-+      11
-+       7
-+      10
-+      16
-+       0
-  (20 rows)
-  
-  QUERY: SELECT unique2 FROM ten_k WHERE unique2 < 20;
-***************
-*** 244,253 ****
-  QUERY: SELECT unique1 FROM tenk1 WHERE unique1 < 5;
-  unique1
-  -------
-!       0
-!       1
-        2
-        3
-!       4
-  (5 rows)
-  
---- 244,253 ----
-  QUERY: SELECT unique1 FROM tenk1 WHERE unique1 < 5;
-  unique1
-  -------
-!       4
-        2
-+       1
-        3
-!       0
-  (5 rows)
-  
-
-----------------------
-
