Debian Codegraph @

mysql-test/suite/s3/partition.test

raw
1 --source include/have_partition.inc
2 --source include/have_s3.inc
3 --source create_database.inc
4
5 --echo # Test for COALESCE PARTITION, ALTER TABLE and ADD PARTITIONS
6 --echo # for tables with HASH partitions
7 CREATE TABLE t1 (
8 c1 INT DEFAULT NULL
9 ) ENGINE=Aria
10 PARTITION BY HASH (c1)
11 PARTITIONS 3;
12 INSERT INTO t1 VALUE (1), (2), (101), (102), (201), (202);
13 ALTER TABLE t1 ENGINE=S3;
14 SELECT count(*) FROM t1;
15 # Check that partition tables are not shown;
16 --replace_result $database s3
17 SHOW TABLES;
18
19 --replace_result $database s3
20 --error ER_UNSUPPORTED_EXTENSION
21 ALTER TABLE t1 COALESCE PARTITION 2;
22 --replace_result $database s3
23 SHOW WARNINGS;
24 ALTER TABLE t1 ADD PARTITION PARTITIONS 6;
25 SELECT count(*) FROM t1;
26 ALTER TABLE t1 ADD COLUMN c INT;
27 SELECT count(*) FROM t1;
28 DROP TABLE t1;
29
30 --echo # Test for simple change engine to S3
31 CREATE TABLE t1 (
32 c1 int DEFAULT NULL,
33 c2 int DEFAULT NULL
34 ) ENGINE=Aria
35 PARTITION BY RANGE (c1)
36 SUBPARTITION BY HASH(c2)
37 SUBPARTITIONS 2
38 (PARTITION p0 VALUES LESS THAN (100),
39 PARTITION p1 VALUES LESS THAN (200),
40 PARTITION p3 VALUES LESS THAN (300));
41
42 INSERT INTO t1 VALUE (1,1), (2,2), (101,101), (102,102), (201,201), (202,202);
43 ALTER TABLE t1 ENGINE=S3;
44 SELECT count(*) FROM t1;
45
46 --echo # Test for rename table
47 RENAME TABLE t1 TO t2;
48 SELECT count(*) FROM t2;
49
50 --echo # Test for TRUNCATE, ANALYZE, CHECK, REBUILD, OPTIMIZE, REPAIR,
51 --echo # ADD, DROP, REORGANIZE partition
52 --error ER_OPEN_AS_READONLY
53 ALTER TABLE t2 TRUNCATE PARTITION p3;
54 --replace_result $database s3
55 ALTER TABLE t2 ANALYZE PARTITION p3;
56 SELECT count(*) FROM t2;
57 --replace_result $database s3
58 ALTER TABLE t2 CHECK PARTITION p3;
59 SELECT count(*) FROM t2;
60 --replace_result $database s3
61 --error ER_UNSUPPORTED_EXTENSION
62 ALTER TABLE t2 REBUILD PARTITION p0, p1;
63 --replace_result $database s3
64 ALTER TABLE t2 OPTIMIZE PARTITION p0, p1;
65 SELECT count(*) FROM t2;
66 --replace_result $database s3
67 ALTER TABLE t2 REPAIR PARTITION p0, p1;
68 SELECT count(*) FROM t2;
69 --replace_result $database s3
70 ALTER TABLE t2 ADD PARTITION (PARTITION p4 VALUES LESS THAN (400));
71 SHOW CREATE TABLE t2;
72 --replace_result $database s3
73 --error ER_UNSUPPORTED_EXTENSION
74 ALTER TABLE t2
75 REORGANIZE PARTITION p4 INTO (
76 PARTITION n0 VALUES LESS THAN (500),
77 PARTITION n1 VALUES LESS THAN (600)
78 );
79 ALTER TABLE t2 DROP PARTITION p3;
80 SHOW CREATE TABLE t2;
81 SELECT count(*) from t2;
82
83 --echo # Test for ALTER TABLE
84 ALTER TABLE t2 ADD COLUMN c INT;
85 SELECT count(*) FROM t2;
86 ALTER TABLE t2 DROP COLUMN c;
87 SELECT count(*) FROM t2;
88
89 --echo # Test for REMOVE PARTITIONING
90 ALTER TABLE t2 REMOVE PARTITIONING;
91 SHOW CREATE TABLE t2;
92 SELECT count(*) FROM t2;
93 DROP TABLE t2;
94
95 --echo # Test for EXCHANGE PARTITION
96 CREATE TABLE t1 (
97 c1 int DEFAULT NULL
98 ) ENGINE=Aria
99 PARTITION BY RANGE (c1)
100 (PARTITION p0 VALUES LESS THAN (100),
101 PARTITION p1 VALUES LESS THAN (200));
102 INSERT INTO t1 VALUE (1), (2), (101), (102);
103 ALTER TABLE t1 ENGINE=S3;
104 CREATE TABLE t_part (
105 c1 int DEFAULT NULL
106 ) ENGINE=Aria;
107 INSERT INTO t_part VALUE (120), (130), (140);
108 ALTER TABLE t_part ENGINE=S3;
109 ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t_part;
110 SELECT count(*) FROM t_part;
111 SELECT count(*) FROM t1;
112 DROP TABLE t1;
113 DROP TABLE t_part;
114
115 #
116 # clean up
117 #
118 --source drop_database.inc