Commit6f4a546

committed

Add an ORDER BY to nail down the expected row order from a query that's

been shown to be sensitive to concurrent autovacuum. Per Alvaro.

1 parenta4df52f commit6f4a546Copy full SHA for 6f4a546

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -249,11 +249,12 @@ SELECT a,b,c,substring(d for 30), length(d) from clstr_tst;`
`249`	`249`	`INSERT INTO clstr_tst (b, c) VALUES (1111, 'this should fail');`
`250`	`250`	`ERROR: insert or update on table "clstr_tst" violates foreign key constraint "clstr_tst_con"`
`251`	`251`	`DETAIL: Key (b)=(1111) is not present in table "clstr_tst_s".`
`252`		`-SELECT conname FROM pg_constraint WHERE conrelid = 'clstr_tst'::regclass;`
	`252`	`+SELECT conname FROM pg_constraint WHERE conrelid = 'clstr_tst'::regclass`
	`253`	`+ORDER BY 1;`
`253`	`254`	`conname`
`254`	`255`	`----------------`
`255`		`- clstr_tst_pkey`
`256`	`256`	`clstr_tst_con`
	`257`	`+ clstr_tst_pkey`
`257`	`258`	`(2 rows)`
`258`	`259`
`259`	`260`	`SELECT relname, relkind,`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -73,7 +73,8 @@ SELECT a,b,c,substring(d for 30), length(d) from clstr_tst;`
`73`	`73`	`-- Verify that foreign key link still works`
`74`	`74`	`INSERT INTO clstr_tst (b, c)VALUES (1111,'this should fail');`
`75`	`75`
`76`		`-SELECT connameFROM pg_constraintWHERE conrelid='clstr_tst'::regclass;`
	`76`	`+SELECT connameFROM pg_constraintWHERE conrelid='clstr_tst'::regclass`
	`77`	`+ORDER BY1;`
`77`	`78`
`78`	`79`
`79`	`80`	`SELECT relname, relkind,`

Comments

(0)