Debian Codegraph @

mysql-test/suite/parts/t/partition_remove.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 SET sql_mode='NO_ENGINE_SUBSTITUTION';
5 CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
6 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
7 SELECT * FROM t1 ORDER BY c1;
8 SHOW TABLES;
9 --replace_result " PAGE_CHECKSUM=0" ""
10 SHOW CREATE TABLE t1;
11 ALTER TABLE t1 REMOVE PARTITIONING;
12 SELECT * FROM t1 ORDER BY c1;
13 SHOW TABLES;
14 --replace_result " PAGE_CHECKSUM=0" ""
15 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
16 CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
17 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
18 SELECT * FROM t1 ORDER BY c1;
19 SHOW TABLES;
20 --replace_result " PAGE_CHECKSUM=0" ""
21 SHOW CREATE TABLE t1;
22 ALTER TABLE t1 REMOVE PARTITIONING;
23 SELECT * FROM t1 ORDER BY c1;
24 SHOW TABLES;
25 --replace_result " PAGE_CHECKSUM=0" ""
26 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
27 CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
28 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
29 SELECT * FROM t1 ORDER BY c1;
30 SHOW TABLES;
31 --replace_result " PAGE_CHECKSUM=0" ""
32 SHOW CREATE TABLE t1;
33 ALTER TABLE t1 REMOVE PARTITIONING;
34 SELECT * FROM t1 ORDER BY c1;
35 SHOW TABLES;
36 --replace_result " PAGE_CHECKSUM=0" ""
37 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
38 CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
39 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
40 SELECT * FROM t1 ORDER BY c1;
41 SHOW TABLES;
42 --replace_result " PAGE_CHECKSUM=0" ""
43 SHOW CREATE TABLE t1;
44 ALTER TABLE t1 REMOVE PARTITIONING;
45 SELECT * FROM t1 ORDER BY c1;
46 SHOW TABLES;
47 --replace_result " PAGE_CHECKSUM=0" ""
48 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
49 CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
50 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
51 SELECT * FROM t1 ORDER BY c1;
52 SHOW TABLES;
53 --replace_result " PAGE_CHECKSUM=0" ""
54 SHOW CREATE TABLE t1;
55 ALTER TABLE t1 REMOVE PARTITIONING;
56 SELECT * FROM t1 ORDER BY c1;
57 SHOW TABLES;
58 --replace_result " PAGE_CHECKSUM=0" ""
59 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
60 CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
61 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
62 SELECT * FROM t1 ORDER BY c1;
63 SHOW TABLES;
64 --replace_result " PAGE_CHECKSUM=0" ""
65 SHOW CREATE TABLE t1;
66 ALTER TABLE t1 REMOVE PARTITIONING;
67 SELECT * FROM t1 ORDER BY c1;
68 SHOW TABLES;
69 --replace_result " PAGE_CHECKSUM=0" ""
70 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
71 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
72 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
73 SELECT * FROM t1 ORDER BY c1;
74 SHOW TABLES;
75 --replace_result " PAGE_CHECKSUM=0" ""
76 SHOW CREATE TABLE t1;
77 ALTER TABLE t1 REMOVE PARTITIONING;
78 SELECT * FROM t1 ORDER BY c1;
79 SHOW TABLES;
80 --replace_result " PAGE_CHECKSUM=0" ""
81 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
82 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
83 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
84 SELECT * FROM t1 ORDER BY c1;
85 SHOW TABLES;
86 --replace_result " PAGE_CHECKSUM=0" ""
87 SHOW CREATE TABLE t1;
88 ALTER TABLE t1 REMOVE PARTITIONING;
89 SELECT * FROM t1 ORDER BY c1;
90 SHOW TABLES;
91 --replace_result " PAGE_CHECKSUM=0" ""
92 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
93 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
94 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
95 SELECT * FROM t1 ORDER BY c1;
96 SHOW TABLES;
97 --replace_result " PAGE_CHECKSUM=0" ""
98 SHOW CREATE TABLE t1;
99 ALTER TABLE t1 REMOVE PARTITIONING;
100 SELECT * FROM t1 ORDER BY c1;
101 SHOW TABLES;
102 --replace_result " PAGE_CHECKSUM=0" ""
103 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
104 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
105 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
106 SELECT * FROM t1 ORDER BY c1;
107 SHOW TABLES;
108 --replace_result " PAGE_CHECKSUM=0" ""
109 SHOW CREATE TABLE t1;
110 ALTER TABLE t1 REMOVE PARTITIONING;
111 SELECT * FROM t1 ORDER BY c1;
112 SHOW TABLES;
113 --replace_result " PAGE_CHECKSUM=0" ""
114 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
115 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
116 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
117 SELECT * FROM t1 ORDER BY c1;
118 SHOW TABLES;
119 --replace_result " PAGE_CHECKSUM=0" ""
120 SHOW CREATE TABLE t1;
121 ALTER TABLE t1 REMOVE PARTITIONING;
122 SELECT * FROM t1 ORDER BY c1;
123 SHOW TABLES;
124 --replace_result " PAGE_CHECKSUM=0" ""
125 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
126 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
127 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
128 SELECT * FROM t1 ORDER BY c1;
129 SHOW TABLES;
130 --replace_result " PAGE_CHECKSUM=0" ""
131 SHOW CREATE TABLE t1;
132 ALTER TABLE t1 REMOVE PARTITIONING;
133 SELECT * FROM t1 ORDER BY c1;
134 SHOW TABLES;
135 --replace_result " PAGE_CHECKSUM=0" ""
136 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
137 SET sql_mode=default;