Commit449cdcd

committed

Stabilize regression tests introduced by259c96f

Add the ORDER BY clause to new queries to avoid ordering ambiguity.Per buildfarm member rorqual.

1 parent259c96f commit449cdcdCopy full SHA for 449cdcd

File tree

-5

lines changed

-5

lines changed

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -871,11 +871,12 @@ CREATE TABLE tp_1_2 PARTITION OF t FOR VALUES FROM (1) TO (2);`
`871`	`871`	`ALTER TABLE t MERGE PARTITIONS (tp_0_1, tp_1_2) INTO tp_0_2;`
`872`	`872`	`SELECT c.relname, a.amname`
`873`	`873`	`FROM pg_class c JOIN pg_am a ON c.relam = a.oid`
`874`		`-WHERE c.oid IN ('t'::regclass, 'tp_0_2'::regclass);`
	`874`	`+WHERE c.oid IN ('t'::regclass, 'tp_0_2'::regclass)`
	`875`	`+ORDER BY c.relname;`
`875`	`876`	`relname \| amname`
`876`	`877`	`---------+-----------------------`
`877`		`- tp_0_2 \| partitions_merge_heap`
`878`	`878`	`t \| partitions_merge_heap`
	`879`	`+ tp_0_2 \| partitions_merge_heap`
`879`	`880`	`(2 rows)`
`880`	`881`
`881`	`882`	`DROP TABLE t;`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1503,7 +1503,8 @@ ALTER TABLE t SPLIT PARTITION tp_0_2 INTO`
`1503`	`1503`	`PARTITION tp_1_2 FOR VALUES FROM (1) TO (2));`
`1504`	`1504`	`SELECT c.relname, a.amname`
`1505`	`1505`	`FROM pg_class c JOIN pg_am a ON c.relam = a.oid`
`1506`		`-WHERE c.oid IN ('t'::regclass, 'tp_0_1'::regclass, 'tp_1_2'::regclass);`
	`1506`	`+WHERE c.oid IN ('t'::regclass, 'tp_0_1'::regclass, 'tp_1_2'::regclass)`
	`1507`	`+ORDER BY c.relname;`
`1507`	`1508`	`relname \| amname`
`1508`	`1509`	`---------+----------------------`
`1509`	`1510`	`t \| partition_split_heap`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -544,7 +544,8 @@ CREATE TABLE tp_1_2 PARTITION OF t FOR VALUES FROM (1) TO (2);`
`544`	`544`	`ALTERTABLE t MERGE PARTITIONS (tp_0_1, tp_1_2) INTO tp_0_2;`
`545`	`545`	`SELECTc.relname,a.amname`
`546`	`546`	`FROM pg_class cJOIN pg_am aONc.relam=a.oid`
`547`		`-WHEREc.oidIN ('t'::regclass,'tp_0_2'::regclass);`
	`547`	`+WHEREc.oidIN ('t'::regclass,'tp_0_2'::regclass)`
	`548`	`+ORDER BYc.relname;`
`548`	`549`	`DROPTABLE t;`
`549`	`550`	`DROP ACCESS METHOD partitions_merge_heap;`
`550`	`551`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -889,7 +889,8 @@ ALTER TABLE t SPLIT PARTITION tp_0_2 INTO`
`889`	`889`	`PARTITION tp_1_2 FORVALUESFROM (1) TO (2));`
`890`	`890`	`SELECTc.relname,a.amname`
`891`	`891`	`FROM pg_class cJOIN pg_am aONc.relam=a.oid`
`892`		`-WHEREc.oidIN ('t'::regclass,'tp_0_1'::regclass,'tp_1_2'::regclass);`
	`892`	`+WHEREc.oidIN ('t'::regclass,'tp_0_1'::regclass,'tp_1_2'::regclass)`
	`893`	`+ORDER BYc.relname;`
`893`	`894`	`DROPTABLE t;`
`894`	`895`	`DROP ACCESS METHOD partition_split_heap;`
`895`	`896`

Comments

(0)