Debian Codegraph @

mysql-test/suite/parts/r/partition_alter_instant.result

raw
1 CREATE TABLE t1 (
2 id INT NOT NULL,
3 name VARCHAR(30))ENGINE=InnoDB ROW_FORMAT=COMPACT CHARACTER SET=latin1
4 PARTITION BY RANGE (id) (
5 PARTITION p0 VALUES LESS THAN (50),
6 PARTITION p1 VALUES LESS THAN (MAXVALUE)
7 );
8 INSERT INTO t1(id, name) VALUES(16, 'Me'), (337, 'ROFL');
9 # Add and drop 31 Instant columns
10 CREATE TABLE t2 LIKE t1;
11 SHOW CREATE TABLE t2;
12 Table Create Table
13 t2 CREATE TABLE `t2` (
14 `id` int(11) NOT NULL,
15 `name` varchar(30) DEFAULT NULL
16 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=COMPACT
17 PARTITION BY RANGE (`id`)
18 (PARTITION `p0` VALUES LESS THAN (50) ENGINE = InnoDB,
19 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = InnoDB)
20 ALTER TABLE t2 REMOVE PARTITIONING;
21 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
22 SHOW CREATE TABLE t2;
23 Table Create Table
24 t2 CREATE TABLE `t2` (
25 `id` int(11) NOT NULL,
26 `name` varchar(30) DEFAULT NULL
27 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=COMPACT
28 ALTER TABLE t1 ADD COLUMN col1 VARCHAR(255) NOT NULL DEFAULT repeat('a', 255), ALGORITHM=INSTANT;
29 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE
30 ALTER TABLE t1 ADD COLUMN col1 VARCHAR(255) NOT NULL DEFAULT repeat('a', 255), ALGORITHM=INPLACE;
31 DROP TABLE t1, t2;