Debian Codegraph @

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

raw
1 --source include/have_partition.inc
2 --source include/have_innodb.inc
3 --source include/have_innodb_16k.inc
4
5 # MDEV-21832 FORCE all partition to rebuild if any one of the
6 # partition does rebuild
7 CREATE TABLE t1 (
8 id INT NOT NULL,
9 name VARCHAR(30))ENGINE=InnoDB ROW_FORMAT=COMPACT CHARACTER SET=latin1
10 PARTITION BY RANGE (id) (
11 PARTITION p0 VALUES LESS THAN (50),
12 PARTITION p1 VALUES LESS THAN (MAXVALUE)
13 );
14
15 INSERT INTO t1(id, name) VALUES(16, 'Me'), (337, 'ROFL');
16
17 --echo # Add and drop 31 Instant columns
18 --disable_query_log
19 let $i = 1;
20 while ($i < 32) {
21 --eval ALTER TABLE t1 ADD COLUMN col$i VARCHAR(255) NOT NULL DEFAULT repeat('a', 255);
22 inc $i;
23 }
24
25 let $i = 31;
26 while ($i > 0) {
27 --eval ALTER TABLE t1 DROP COLUMN col$i
28 dec $i;
29 }
30 --enable_query_log
31
32 CREATE TABLE t2 LIKE t1;
33 SHOW CREATE TABLE t2;
34 ALTER TABLE t2 REMOVE PARTITIONING;
35 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
36 SHOW CREATE TABLE t2;
37 --error ER_ALTER_OPERATION_NOT_SUPPORTED
38 ALTER TABLE t1 ADD COLUMN col1 VARCHAR(255) NOT NULL DEFAULT repeat('a', 255), ALGORITHM=INSTANT;
39 ALTER TABLE t1 ADD COLUMN col1 VARCHAR(255) NOT NULL DEFAULT repeat('a', 255), ALGORITHM=INPLACE;
40 DROP TABLE t1, t2;