Debian Codegraph @

mysql-test/suite/engines/funcs/t/tc_partition_remove.test

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