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

Commit47fb4dd

Browse files
committed
fix tests for pg_pathman version 1.4
1 parentd4b9e77 commit47fb4dd

File tree

1 file changed

+44
-46
lines changed

1 file changed

+44
-46
lines changed

‎contrib/test_partitioning/expected/partition.out

Lines changed: 44 additions & 46 deletions
Original file line numberDiff line numberDiff line change
@@ -12,39 +12,38 @@ PARTITION BY RANGE(id) INTERVAL (100)
1212
PARTITION abc_inf VALUES LESS THAN (100),
1313
PARTITION abc_100 VALUES LESS THAN (200)
1414
);
15-
NOTICE: sequence "abc_seq" does not exist, skipping
1615
ALTER TABLE abc ADD PARTITION abc_200 VALUES LESS THAN (400);
1716
ALTER TABLE abc SPLIT PARTITION abc_200 AT (300) INTO (PARTITION abc_200, PARTITION abc_300);
1817
ALTER TABLE abc MERGE PARTITIONS abc_100, abc_200, abc_300 INTO PARTITION abc_100;
1918
SELECT * FROM pathman_partition_list;
20-
parent | partition | parttype |partattr | range_min | range_max
21-
--------+-----------+----------+----------+-----------+-----------
22-
abc | abc_inf | 2 | id| NULL | 100
23-
abc | abc_100 | 2 | id| 100 | 400
19+
parent | partition | parttype |expr | range_min | range_max
20+
--------+-----------+----------+------+-----------+-----------
21+
abc | abc_inf | 2 | id| | 100
22+
abc | abc_100 | 2 | id | 100 | 400
2423
(2 rows)
2524

2625
/* Drop partition should shift next partition's lower bound */
2726
ALTER TABLE abc ADD PARTITION abc_400 VALUES LESS THAN (500);
2827
ALTER TABLE abc DROP PARTITION abc_100;
2928
SELECT * FROM pathman_partition_list;
30-
parent | partition | parttype |partattr | range_min | range_max
31-
--------+-----------+----------+----------+-----------+-----------
32-
abc | abc_inf | 2 | id| NULL | 100
33-
abc | abc_400 | 2 | id| 100 | 500
29+
parent | partition | parttype |expr | range_min | range_max
30+
--------+-----------+----------+------+-----------+-----------
31+
abc | abc_inf | 2 | id| | 100
32+
abc | abc_400 | 2 | id | 100 | 500
3433
(2 rows)
3534

3635
/* Inserting values into area not covered by partitions should create new partition */
3736
INSERT INTO abc VALUES (550);
3837
SELECT * FROM pathman_partition_list;
39-
parent | partition | parttype |partattr | range_min | range_max
40-
--------+-----------+----------+----------+-----------+-----------
41-
abc | abc_inf | 2 | id| NULL | 100
42-
abc | abc_400 | 2 | id| 100 | 500
43-
abc | abc_1 | 2 | id| 500 | 600
38+
parent | partition | parttype |expr | range_min | range_max
39+
--------+-----------+----------+------+-----------+-----------
40+
abc | abc_inf | 2 | id| | 100
41+
abc | abc_400 | 2 | id | 100 | 500
42+
abc | abc_1 | 2 | id | 500 | 600
4443
(3 rows)
4544

4645
DROP TABLE abc CASCADE;
47-
NOTICE: drop cascades to3 other objects
46+
NOTICE: drop cascades to4 other objects
4847
/*
4948
* Create range partitioned table (in contrast to interval-partitioned in terms
5049
* of Oracle)
@@ -57,19 +56,19 @@ PARTITION BY RANGE(id)
5756
);
5857
/* Inserting should produce an error because interval hasn't been set */
5958
INSERT INTO abc VALUES (250);
60-
ERROR: cannotfind appropriate partition for key '250'
59+
ERROR: cannotspawn new partition for key '250'
6160
DROP TABLE abc CASCADE;
62-
NOTICE: drop cascades to2 other objects
61+
NOTICE: drop cascades to3 other objects
6362
/* Create hash partitioned table */
6463
CREATE TABLE abc (id serial)
6564
PARTITION BY HASH (id) PARTITIONS (4);
6665
SELECT * FROM pathman_partition_list;
67-
parent | partition | parttype |partattr | range_min | range_max
68-
--------+-----------+----------+----------+-----------+-----------
69-
abc | abc_0 | 1 | id| |
70-
abc | abc_1 | 1 | id| |
71-
abc | abc_2 | 1 | id| |
72-
abc | abc_3 | 1 | id| |
66+
parent | partition | parttype |expr | range_min | range_max
67+
--------+-----------+----------+------+-----------+-----------
68+
abc | abc_0 | 1 | id | |
69+
abc | abc_1 | 1 | id | |
70+
abc | abc_2 | 1 | id | |
71+
abc | abc_3 | 1 | id | |
7372
(4 rows)
7473

7574
DROP TABLE abc CASCADE;
@@ -81,10 +80,10 @@ PARTITION BY HASH (id)
8180
PARTITION abc_second
8281
);
8382
SELECT * FROM pathman_partition_list;
84-
parent | partition | parttype |partattr | range_min | range_max
85-
--------+------------+----------+----------+-----------+-----------
86-
abc | abc_first | 1 | id| |
87-
abc | abc_second | 1 | id| |
83+
parent | partition | parttype |expr | range_min | range_max
84+
--------+------------+----------+------+-----------+-----------
85+
abc | abc_first | 1 | id | |
86+
abc | abc_second | 1 | id | |
8887
(2 rows)
8988

9089
DROP TABLE abc CASCADE;
@@ -93,23 +92,22 @@ CREATE TABLE abc(id serial);
9392
INSERT INTO abc SELECT generate_series(1, 1000);
9493
ALTER TABLE abc PARTITION BY RANGE (id) START FROM (1) INTERVAL (100);
9594
SELECT * FROM pathman_partition_list;
96-
parent | partition | parttype |partattr | range_min | range_max
97-
--------+-----------+----------+----------+-----------+-----------
98-
abc | abc_inf | 2 | id| NULL | 1
99-
abc | abc_1 | 2 | id| 1 | 101
100-
abc | abc_2 | 2 | id| 101 | 201
101-
abc | abc_3 | 2 | id| 201 | 301
102-
abc | abc_4 | 2 | id| 301 | 401
103-
abc | abc_5 | 2 | id| 401 | 501
104-
abc | abc_6 | 2 | id| 501 | 601
105-
abc | abc_7 | 2 | id| 601 | 701
106-
abc | abc_8 | 2 | id| 701 | 801
107-
abc | abc_9 | 2 | id| 801 | 901
108-
abc | abc_10 | 2 | id| 901 | 1001
95+
parent | partition | parttype |expr | range_min | range_max
96+
--------+-----------+----------+------+-----------+-----------
97+
abc | abc_inf | 2 | id| | 1
98+
abc | abc_1 | 2 | id | 1 | 101
99+
abc | abc_2 | 2 | id | 101 | 201
100+
abc | abc_3 | 2 | id | 201 | 301
101+
abc | abc_4 | 2 | id | 301 | 401
102+
abc | abc_5 | 2 | id | 401 | 501
103+
abc | abc_6 | 2 | id | 501 | 601
104+
abc | abc_7 | 2 | id | 601 | 701
105+
abc | abc_8 | 2 | id | 701 | 801
106+
abc | abc_9 | 2 | id | 801 | 901
107+
abc | abc_10 | 2 | id | 901 | 1001
109108
(11 rows)
110109

111110
SELECT drop_partitions('abc');
112-
NOTICE: function public.abc_upd_trig_func() does not exist, skipping
113111
NOTICE: 100 rows copied from abc_1
114112
NOTICE: 100 rows copied from abc_2
115113
NOTICE: 100 rows copied from abc_3
@@ -128,11 +126,11 @@ NOTICE: 0 rows copied from abc_inf
128126

129127
ALTER TABLE abc PARTITION BY HASH (id) PARTITIONS (3);
130128
SELECT * FROM pathman_partition_list;
131-
parent | partition | parttype |partattr | range_min | range_max
132-
--------+-----------+----------+----------+-----------+-----------
133-
abc | abc_0 | 1 | id| |
134-
abc | abc_1 | 1 | id| |
135-
abc | abc_2 | 1 | id| |
129+
parent | partition | parttype |expr | range_min | range_max
130+
--------+-----------+----------+------+-----------+-----------
131+
abc | abc_0 | 1 | id | |
132+
abc | abc_1 | 1 | id | |
133+
abc | abc_2 | 1 | id | |
136134
(3 rows)
137135

138136
DROP TABLE abc CASCADE;

0 commit comments

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