Commit7898a49

committed

Add ORDER BY to new test query

Per buildfarm.

1 parent0574825 commit7898a49Copy full SHA for 7898a49

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -443,7 +443,8 @@ ALTER INDEX t_a_idx ATTACH PARTITION tp_pkey;`
`443`	`443`	`ALTER INDEX t_b_idx ATTACH PARTITION tp_b_a_key;`
`444`	`444`	`ALTER TABLE t DETACH PARTITION tp;`
`445`	`445`	`SELECT conname, conparentid, conislocal, coninhcount`
`446`		`- FROM pg_constraint WHERE conname IN ('tp_pkey', 'tp_b_a_key');`
	`446`	`+ FROM pg_constraint WHERE conname IN ('tp_pkey', 'tp_b_a_key')`
	`447`	`+ ORDER BY conname DESC;`
`447`	`448`	`DROP TABLE t, tp;`
`448`	`449`
`449`	`450`	`CREATE TEMP TABLE t (a integer) PARTITION BY LIST (a);`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -612,7 +612,8 @@ ALTER INDEX t_a_idx ATTACH PARTITION tp_pkey;`
`612`	`612`	`ALTER INDEX t_b_idx ATTACH PARTITION tp_b_a_key;`
`613`	`613`	`ALTER TABLE t DETACH PARTITION tp;`
`614`	`614`	`SELECT conname, conparentid, conislocal, coninhcount`
`615`		`- FROM pg_constraint WHERE conname IN ('tp_pkey', 'tp_b_a_key');`
	`615`	`+ FROM pg_constraint WHERE conname IN ('tp_pkey', 'tp_b_a_key')`
	`616`	`+ ORDER BY conname DESC;`
`616`	`617`	`conname \| conparentid \| conislocal \| coninhcount`
`617`	`618`	`------------+-------------+------------+-------------`
`618`	`619`	`tp_pkey \| 0 \| t \| 0`

Comments

(0)