Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

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

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit143fb25

Browse files
committed
fix isolation tests for branch 'picky_nodes'
1 parentd43bedb commit143fb25

File tree

2 files changed

+25
-26
lines changed

2 files changed

+25
-26
lines changed

‎expected/rollback_on_create_partitions.out‎

Lines changed: 24 additions & 24 deletions
Original file line numberDiff line numberDiff line change
@@ -74,8 +74,8 @@ create_range_partitions
7474

7575
10
7676
step savepoint_b: SAVEPOINT b;
77-
step drop_partitions: SELECTdrop_range_partitions('range_rel');
78-
drop_range_partitions
77+
step drop_partitions: SELECTdrop_partitions('range_rel');
78+
drop_partitions
7979

8080
10
8181
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
@@ -100,8 +100,8 @@ create_range_partitions
100100

101101
10
102102
step savepoint_b: SAVEPOINT b;
103-
step drop_partitions: SELECTdrop_range_partitions('range_rel');
104-
drop_range_partitions
103+
step drop_partitions: SELECTdrop_partitions('range_rel');
104+
drop_partitions
105105

106106
10
107107
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
@@ -124,8 +124,8 @@ create_range_partitions
124124

125125
10
126126
step savepoint_b: SAVEPOINT b;
127-
step drop_partitions: SELECTdrop_range_partitions('range_rel');
128-
drop_range_partitions
127+
step drop_partitions: SELECTdrop_partitions('range_rel');
128+
drop_partitions
129129

130130
10
131131
step savepoint_c: SAVEPOINT c;
@@ -161,8 +161,8 @@ create_range_partitions
161161

162162
10
163163
step savepoint_b: SAVEPOINT b;
164-
step drop_partitions: SELECTdrop_range_partitions('range_rel');
165-
drop_range_partitions
164+
step drop_partitions: SELECTdrop_partitions('range_rel');
165+
drop_partitions
166166

167167
10
168168
step savepoint_c: SAVEPOINT c;
@@ -207,8 +207,8 @@ create_range_partitions
207207

208208
10
209209
step savepoint_b: SAVEPOINT b;
210-
step drop_partitions: SELECTdrop_range_partitions('range_rel');
211-
drop_range_partitions
210+
step drop_partitions: SELECTdrop_partitions('range_rel');
211+
drop_partitions
212212

213213
10
214214
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
@@ -238,8 +238,8 @@ create_range_partitions
238238

239239
10
240240
step savepoint_b: SAVEPOINT b;
241-
step drop_partitions: SELECTdrop_range_partitions('range_rel');
242-
drop_range_partitions
241+
step drop_partitions: SELECTdrop_partitions('range_rel');
242+
drop_partitions
243243

244244
10
245245
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
@@ -269,8 +269,8 @@ create_range_partitions
269269

270270
10
271271
step savepoint_b: SAVEPOINT b;
272-
step drop_partitions: SELECTdrop_range_partitions('range_rel');
273-
drop_range_partitions
272+
step drop_partitions: SELECTdrop_partitions('range_rel');
273+
drop_partitions
274274

275275
10
276276
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
@@ -280,8 +280,8 @@ Seq Scan on range_rel
280280
step savepoint_c: SAVEPOINT c;
281281
WARNING: All changes in partitioned table 'range_rel' will be discarded
282282
step rollback_b: ROLLBACK TO SAVEPOINT b;
283-
step drop_partitions: SELECTdrop_range_partitions('range_rel');
284-
drop_range_partitions
283+
step drop_partitions: SELECTdrop_partitions('range_rel');
284+
drop_partitions
285285

286286
10
287287
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
@@ -305,8 +305,8 @@ create_range_partitions
305305

306306
10
307307
step savepoint_b: SAVEPOINT b;
308-
step drop_partitions: SELECTdrop_range_partitions('range_rel');
309-
drop_range_partitions
308+
step drop_partitions: SELECTdrop_partitions('range_rel');
309+
drop_partitions
310310

311311
10
312312
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
@@ -316,8 +316,8 @@ Seq Scan on range_rel
316316
step savepoint_c: SAVEPOINT c;
317317
WARNING: All changes in partitioned table 'range_rel' will be discarded
318318
step rollback_b: ROLLBACK TO SAVEPOINT b;
319-
step drop_partitions: SELECTdrop_range_partitions('range_rel');
320-
drop_range_partitions
319+
step drop_partitions: SELECTdrop_partitions('range_rel');
320+
drop_partitions
321321

322322
10
323323
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
@@ -339,8 +339,8 @@ create_range_partitions
339339

340340
10
341341
step savepoint_b: SAVEPOINT b;
342-
step drop_partitions: SELECTdrop_range_partitions('range_rel');
343-
drop_range_partitions
342+
step drop_partitions: SELECTdrop_partitions('range_rel');
343+
drop_partitions
344344

345345
10
346346
WARNING: All changes in partitioned table 'range_rel' will be discarded
@@ -380,8 +380,8 @@ create_range_partitions
380380

381381
10
382382
step savepoint_b: SAVEPOINT b;
383-
step drop_partitions: SELECTdrop_range_partitions('range_rel');
384-
drop_range_partitions
383+
step drop_partitions: SELECTdrop_partitions('range_rel');
384+
drop_partitions
385385

386386
10
387387
WARNING: All changes in partitioned table 'range_rel' will be discarded

‎specs/rollback_on_create_partitions.spec‎

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -6,7 +6,6 @@ setup
66

77
teardown
88
{
9-
SELECTdrop_range_partitions('range_rel');
109
DROPTABLErange_relCASCADE;
1110
DROPEXTENSIONpg_pathman;
1211
}
@@ -17,7 +16,7 @@ step "rollback" { ROLLBACK; }
1716
step"commit" {COMMIT; }
1817
step"insert_data" {INSERTINTOrange_relSELECTgenerate_series(1,10000); }
1918
step"create_partitions" {SELECTcreate_range_partitions('range_rel','id',1,1000); }
20-
step"drop_partitions" {SELECTdrop_range_partitions('range_rel'); }
19+
step"drop_partitions" {SELECTdrop_partitions('range_rel'); }
2120
step"savepoint_a" {SAVEPOINTa; }
2221
step"rollback_a" {ROLLBACKTOSAVEPOINTa; }
2322
step"savepoint_b" {SAVEPOINTb; }

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp