NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commit8902f79

committed

Remove unnecessary and unreliable test

1 parent3b14bb7 commit8902f79Copy full SHA for 8902f79

File tree

3 files changed

-130

lines changed

src/test/regress
- expected
  - prepared_xacts.out
  - prepared_xacts_1.out
- sql
  - prepared_xacts.sql

3 files changed

-130

lines changed

`‎src/test/regress/expected/prepared_xacts.out`

Lines changed: 0 additions & 50 deletions

Original file line number	Diff line number	Diff line change
`@@ -247,58 +247,8 @@ SELECT gid FROM pg_prepared_xacts;`
`247`	`247`	`-----`
`248`	`248`	`(0 rows)`
`249`	`249`
`250`		`-CREATE TABLE pxtest5 (a SERIAL);`
`251`		`-INSERT INTO pxtest5 DEFAULT VALUES;`
`252`		`-SELECT * FROM pxtest5;`
`253`		`- a`
`254`		`----`
`255`		`- 1`
`256`		`-(1 row)`
`257`		`-`
`258`		`-BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;`
`259`		`- INSERT INTO pxtest5 DEFAULT VALUES;`
`260`		`- INSERT INTO pxtest5 DEFAULT VALUES;`
`261`		`- TRUNCATE pxtest5;`
`262`		`- INSERT INTO pxtest5 DEFAULT VALUES;`
`263`		`-PREPARE TRANSACTION 'trunc-and-pgstat';`
`264`		`-SELECT pg_sleep(0.5);`
`265`		`- pg_sleep`
`266`		`-----------`
`267`		`-`
`268`		`-(1 row)`
`269`		`-`
`270`		`-SELECT n_tup_ins, n_tup_upd, n_tup_del, n_live_tup, n_dead_tup`
`271`		`- FROM pg_stat_user_tables`
`272`		`- WHERE relname='pxtest5';`
`273`		`- n_tup_ins \| n_tup_upd \| n_tup_del \| n_live_tup \| n_dead_tup`
`274`		`------------+-----------+-----------+------------+------------`
`275`		`- 1 \| 0 \| 0 \| 1 \| 0`
`276`		`-(1 row)`
`277`		`-`
`278`		`-COMMIT PREPARED 'trunc-and-pgstat';`
`279`		`-SELECT pg_sleep(0.5);`
`280`		`- pg_sleep`
`281`		`-----------`
`282`		`-`
`283`		`-(1 row)`
`284`		`-`
`285`		`-SELECT n_tup_ins, n_tup_upd, n_tup_del, n_live_tup, n_dead_tup`
`286`		`- FROM pg_stat_user_tables`
`287`		`- WHERE relname='pxtest5';`
`288`		`- n_tup_ins \| n_tup_upd \| n_tup_del \| n_live_tup \| n_dead_tup`
`289`		`------------+-----------+-----------+------------+------------`
`290`		`- 2 \| 0 \| 0 \| 1 \| 0`
`291`		`-(1 row)`
`292`		`-`
`293`		`-SELECT * FROM pxtest5;`
`294`		`- a`
`295`		`----`
`296`		`- 4`
`297`		`-(1 row)`
`298`		`-`
`299`	`250`	`-- Clean up`
`300`	`251`	`DROP TABLE pxtest2;`
`301`	`252`	`DROP TABLE pxtest3; -- will still be there if prepared xacts are disabled`
`302`	`253`	`ERROR: table "pxtest3" does not exist`
`303`	`254`	`DROP TABLE pxtest4;`
`304`		`-DROP TABLE pxtest5;`

`‎src/test/regress/expected/prepared_xacts_1.out`

Lines changed: 0 additions & 53 deletions

Original file line number	Diff line number	Diff line change
`@@ -249,62 +249,9 @@ SELECT gid FROM pg_prepared_xacts;`
`249`	`249`	`-----`
`250`	`250`	`(0 rows)`
`251`	`251`
`252`		`-CREATE TABLE pxtest5 (a SERIAL);`
`253`		`-INSERT INTO pxtest5 DEFAULT VALUES;`
`254`		`-SELECT * FROM pxtest5;`
`255`		`- a`
`256`		`----`
`257`		`- 1`
`258`		`-(1 row)`
`259`		`-`
`260`		`-BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;`
`261`		`- INSERT INTO pxtest5 DEFAULT VALUES;`
`262`		`- INSERT INTO pxtest5 DEFAULT VALUES;`
`263`		`- TRUNCATE pxtest5;`
`264`		`- INSERT INTO pxtest5 DEFAULT VALUES;`
`265`		`-PREPARE TRANSACTION 'trunc-and-pgstat';`
`266`		`-ERROR: prepared transactions are disabled`
`267`		`-HINT: Set max_prepared_transactions to a nonzero value.`
`268`		`-SELECT pg_sleep(0.5);`
`269`		`- pg_sleep`
`270`		`-----------`
`271`		`-`
`272`		`-(1 row)`
`273`		`-`
`274`		`-SELECT n_tup_ins, n_tup_upd, n_tup_del, n_live_tup, n_dead_tup`
`275`		`- FROM pg_stat_user_tables`
`276`		`- WHERE relname='pxtest5';`
`277`		`- n_tup_ins \| n_tup_upd \| n_tup_del \| n_live_tup \| n_dead_tup`
`278`		`------------+-----------+-----------+------------+------------`
`279`		`- 3 \| 0 \| 0 \| 1 \| 2`
`280`		`-(1 row)`
`281`		`-`
`282`		`-COMMIT PREPARED 'trunc-and-pgstat';`
`283`		`-ERROR: prepared transaction with identifier "trunc-and-pgstat" does not exist`
`284`		`-SELECT pg_sleep(0.5);`
`285`		`- pg_sleep`
`286`		`-----------`
`287`		`-`
`288`		`-(1 row)`
`289`		`-`
`290`		`-SELECT n_tup_ins, n_tup_upd, n_tup_del, n_live_tup, n_dead_tup`
`291`		`- FROM pg_stat_user_tables`
`292`		`- WHERE relname='pxtest5';`
`293`		`- n_tup_ins \| n_tup_upd \| n_tup_del \| n_live_tup \| n_dead_tup`
`294`		`------------+-----------+-----------+------------+------------`
`295`		`- 3 \| 0 \| 0 \| 1 \| 2`
`296`		`-(1 row)`
`297`		`-`
`298`		`-SELECT * FROM pxtest5;`
`299`		`- a`
`300`		`----`
`301`		`- 1`
`302`		`-(1 row)`
`303`		`-`
`304`	`252`	`-- Clean up`
`305`	`253`	`DROP TABLE pxtest2;`
`306`	`254`	`ERROR: table "pxtest2" does not exist`
`307`	`255`	`DROP TABLE pxtest3; -- will still be there if prepared xacts are disabled`
`308`	`256`	`DROP TABLE pxtest4;`
`309`	`257`	`ERROR: table "pxtest4" does not exist`
`310`		`-DROP TABLE pxtest5;`

`‎src/test/regress/sql/prepared_xacts.sql`

Lines changed: 0 additions & 27 deletions

Original file line number	Diff line number	Diff line change
`@@ -152,34 +152,7 @@ SELECT * FROM pxtest3;`
`152`	`152`	`-- There should be no prepared transactions`
`153`	`153`	`SELECT gidFROM pg_prepared_xacts;`
`154`	`154`
`155`		`-CREATETABLEpxtest5 (aSERIAL);`
`156`		`-INSERT INTO pxtest5 DEFAULTVALUES;`
`157`		`-`
`158`		`-SELECT*FROM pxtest5;`
`159`		`-`
`160`		`-BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;`
`161`		`-INSERT INTO pxtest5 DEFAULTVALUES;`
`162`		`-INSERT INTO pxtest5 DEFAULTVALUES;`
`163`		`- TRUNCATE pxtest5;`
`164`		`-INSERT INTO pxtest5 DEFAULTVALUES;`
`165`		`-PREPARE TRANSACTION'trunc-and-pgstat';`
`166`		`-`
`167`		`-SELECT pg_sleep(0.5);`
`168`		`-SELECT n_tup_ins, n_tup_upd, n_tup_del, n_live_tup, n_dead_tup`
`169`		`-FROM pg_stat_user_tables`
`170`		`-WHERE relname='pxtest5';`
`171`		`-`
`172`		`-COMMIT PREPARED'trunc-and-pgstat';`
`173`		`-`
`174`		`-SELECT pg_sleep(0.5);`
`175`		`-SELECT n_tup_ins, n_tup_upd, n_tup_del, n_live_tup, n_dead_tup`
`176`		`-FROM pg_stat_user_tables`
`177`		`-WHERE relname='pxtest5';`
`178`		`-`
`179`		`-SELECT*FROM pxtest5;`
`180`		`-`
`181`	`155`	`-- Clean up`
`182`	`156`	`DROPTABLE pxtest2;`
`183`	`157`	`DROPTABLE pxtest3;-- will still be there if prepared xacts are disabled`
`184`	`158`	`DROPTABLE pxtest4;`
`185`		`-DROPTABLE pxtest5;`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit8902f79

File tree

3 files changed

3 files changed

`‎src/test/regress/expected/prepared_xacts.out`

`‎src/test/regress/expected/prepared_xacts_1.out`

`‎src/test/regress/sql/prepared_xacts.sql`

0 commit comments