NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commite509e7f

committed

Avoid use of DROP TABLE .. CASCADE in partitioning tests.

This isn't really guaranteed to always produce exactly the sameoutput; the order can change from run to run.See related cleanup in257d815.

1 parentd26fa4f commite509e7fCopy full SHA for e509e7f

File tree

2 files changed

-24

lines changed

src/test/regress
- expected
  - insert.out
- sql
  - insert.sql

2 files changed

-24

lines changed

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

Lines changed: 4 additions & 22 deletions

Original file line number	Diff line number	Diff line change
`@@ -314,28 +314,10 @@ select tableoid::regclass::text, a, min(b) as min_b, max(b) as max_b from list_p`
`314`	`314`	`(9 rows)`
`315`	`315`
`316`	`316`	`-- cleanup`
`317`		`-drop table range_parted cascade;`
`318`		`-NOTICE: drop cascades to 4 other objects`
`319`		`-DETAIL: drop cascades to table part1`
`320`		`-drop cascades to table part2`
`321`		`-drop cascades to table part3`
`322`		`-drop cascades to table part4`
`323`		`-drop table list_parted cascade;`
`324`		`-NOTICE: drop cascades to 14 other objects`
`325`		`-DETAIL: drop cascades to table part_aa_bb`
`326`		`-drop cascades to table part_cc_dd`
`327`		`-drop cascades to table part_null`
`328`		`-drop cascades to table part_ee_ff`
`329`		`-drop cascades to table part_ee_ff1`
`330`		`-drop cascades to table part_ee_ff2`
`331`		`-drop cascades to table part_ee_ff3`
`332`		`-drop cascades to table part_ee_ff3_1`
`333`		`-drop cascades to table part_ee_ff3_2`
`334`		`-drop cascades to table part_gg`
`335`		`-drop cascades to table part_gg1`
`336`		`-drop cascades to table part_gg2`
`337`		`-drop cascades to table part_gg2_1`
`338`		`-drop cascades to table part_gg2_2`
	`317`	`+drop table part1, part2, part3, part4, range_parted;`
	`318`	`+drop table part_ee_ff3_1, part_ee_ff3_2, part_ee_ff1, part_ee_ff2, part_ee_ff3;`
	`319`	`+drop table part_ee_ff, part_gg2_2, part_gg2_1, part_gg2, part_gg1, part_gg;`
	`320`	`+drop table part_aa_bb, part_cc_dd, part_null, list_parted;`
`339`	`321`	`-- more tests for certain multi-level partitioning scenarios`
`340`	`322`	`create table p (a int, b int) partition by range (a, b);`
`341`	`323`	`create table p1 (b int, a int not null) partition by range (b);`

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

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -186,8 +186,10 @@ insert into list_parted (b) values (1);`
`186`	`186`	`select tableoid::regclass::text, a,min(b)as min_b,max(b)as max_bfrom list_partedgroup by1,2order by1;`
`187`	`187`
`188`	`188`	`-- cleanup`
`189`		`-droptable range_parted cascade;`
`190`		`-droptable list_parted cascade;`
	`189`	`+droptable part1, part2, part3, part4, range_parted;`
	`190`	`+droptable part_ee_ff3_1, part_ee_ff3_2, part_ee_ff1, part_ee_ff2, part_ee_ff3;`
	`191`	`+droptable part_ee_ff, part_gg2_2, part_gg2_1, part_gg2, part_gg1, part_gg;`
	`192`	`+droptable part_aa_bb, part_cc_dd, part_null, list_parted;`
`191`	`193`
`192`	`194`	`-- more tests for certain multi-level partitioning scenarios`
`193`	`195`	`createtablep (aint, bint) partition by range (a, b);`

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!

Commite509e7f

File tree

2 files changed

2 files changed

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

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

0 commit comments