Debian Codegraph @

mysql-test/suite/innodb/t/alter_algorithm2.test

raw
1 --source include/have_innodb.inc
2 CREATE TABLE t1 (a INT)ENGINE=InnoDB;
3 INSERT INTO t1 VALUES(1);
4
5 --enable_info
6 PREPARE stmt FROM 'ALTER TABLE t1 ADD KEY idx(a)';
7 PREPARE stmt1 FROM 'ALTER TABLE t1 DROP KEY idx';
8 DELIMITER |;
9 CREATE OR REPLACE PROCEDURE p1()
10 BEGIN
11 ALTER TABLE t1 ADD KEY idx2(a);
12 END|
13
14 CREATE OR REPLACE PROCEDURE p2()
15 BEGIN
16 ALTER TABLE t1 DROP KEY idx2;
17 END|
18 DELIMITER ;|
19
20 EXECUTE stmt;
21 EXECUTE stmt1;
22 call p1();
23 call p2();
24
25 DROP TABLE t1;
26 DROP PROCEDURE p1;
27 DROP PROCEDURE p2;
28
29 SET @save_allowed= @@GLOBAL.innodb_instant_alter_column_allowed;
30 SET GLOBAL innodb_instant_alter_column_allowed=never;
31
32 CREATE TABLE t1(id INT PRIMARY KEY,
33 col1 INT UNSIGNED NOT NULL UNIQUE)ENGINE=InnoDB;
34 INSERT INTO t1 VALUES(1,1),(2,2),(3,3);
35 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
36 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=INSTANT;
37 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
38 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=NOCOPY;
39 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=DEFAULT;
40 ALTER TABLE t1 DROP PRIMARY KEY, ALGORITHM=DEFAULT;
41 DROP TABLE t1;
42 --disable_info
43 SET GLOBAL innodb_instant_alter_column_allowed=@save_allowed;