*** expected/float8.outFri Feb 20 00:08:58 1998

--- results/float8.outThu Feb26 23:22:19 1998

--- results/float8.outSat Feb28 16:53:53 1998

***************

*** 9,17 ****

QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');

----------------------

*** expected/numerology.outFri Feb 20 00:09:37 1998

--- results/numerology.outThu Feb26 23:22:20 1998

--- results/numerology.outSat Feb28 16:53:53 1998

***************

*** 36,44 ****

| 0

----------------------

*** expected/geometry.outFri Feb 20 00:09:04 1998

--- results/geometry.outThu Feb26 23:22:24 1998

--- results/geometry.outSat Feb28 16:53:57 1998

***************

*** 100,106 ****

|(5.1,34.5)|[(1,2),(3,4)] |(3,4)

----------------------

*** expected/tinterval.outFri Feb 20 00:12:49 1998

--- results/tinterval.outThu Feb26 23:22:28 1998

--- results/tinterval.outSat Feb28 16:54:00 1998

***************

*** 110,129 ****

ORDER BY interval1, interval2;

----------------------

*** expected/constraints.outThu Feb 26 23:21:56 1998

--- results/constraints.outThu 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.outFri Feb 20 00:08:41 1998

--- results/create_index.outThu Feb26 23:23:20 1998

--- results/create_index.outSat Feb28 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);

----------------------

*** expected/sanity_check.outFri Feb 20 00:10:05 1998

--- results/sanity_check.outThu Feb26 23:23:33 1998

--- results/sanity_check.outSat Feb28 16:55:27 1998

***************

*** 5,20 ****

ORDER BY relname;

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.outFri Feb 20 00:10:04 1998

--- results/random.outThu Feb26 23:23:38 1998

--- results/random.outSat Feb28 16:55:32 1998

***************

*** 7,18 ****

QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);

----------------------

*** expected/alter_table.outFri Feb 20 00:08:33 1998

--- results/alter_table.outThu 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)

----------------------