Debian Codegraph @

mysql-test/suite/innodb/r/alter_algorithm2.result

raw
1 CREATE TABLE t1 (a INT)ENGINE=InnoDB;
2 INSERT INTO t1 VALUES(1);
3 PREPARE stmt FROM 'ALTER TABLE t1 ADD KEY idx(a)';
4 affected rows: 0
5 info: Statement prepared
6 PREPARE stmt1 FROM 'ALTER TABLE t1 DROP KEY idx';
7 affected rows: 0
8 info: Statement prepared
9 CREATE OR REPLACE PROCEDURE p1()
10 BEGIN
11 ALTER TABLE t1 ADD KEY idx2(a);
12 END|
13 affected rows: 0
14 CREATE OR REPLACE PROCEDURE p2()
15 BEGIN
16 ALTER TABLE t1 DROP KEY idx2;
17 END|
18 affected rows: 0
19 EXECUTE stmt;
20 affected rows: 0
21 info: Records: 0 Duplicates: 0 Warnings: 0
22 EXECUTE stmt1;
23 affected rows: 0
24 info: Records: 0 Duplicates: 0 Warnings: 0
25 call p1();
26 affected rows: 0
27 call p2();
28 affected rows: 0
29 DROP TABLE t1;
30 affected rows: 0
31 DROP PROCEDURE p1;
32 affected rows: 0
33 DROP PROCEDURE p2;
34 affected rows: 0
35 SET @save_allowed= @@GLOBAL.innodb_instant_alter_column_allowed;
36 affected rows: 0
37 SET GLOBAL innodb_instant_alter_column_allowed=never;
38 affected rows: 0
39 CREATE TABLE t1(id INT PRIMARY KEY,
40 col1 INT UNSIGNED NOT NULL UNIQUE)ENGINE=InnoDB;
41 affected rows: 0
42 INSERT INTO t1 VALUES(1,1),(2,2),(3,3);
43 affected rows: 3
44 info: Records: 3 Duplicates: 0 Warnings: 0
45 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=INSTANT;
46 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: innodb_instant_alter_column_allowed=never. Try ALGORITHM=INPLACE
47 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=NOCOPY;
48 ERROR 0A000: ALGORITHM=NOCOPY is not supported. Reason: innodb_instant_alter_column_allowed=never. Try ALGORITHM=INPLACE
49 ALTER TABLE t1 DROP COLUMN col1, ALGORITHM=DEFAULT;
50 affected rows: 0
51 info: Records: 0 Duplicates: 0 Warnings: 0
52 ALTER TABLE t1 DROP PRIMARY KEY, ALGORITHM=DEFAULT;
53 affected rows: 3
54 info: Records: 3 Duplicates: 0 Warnings: 0
55 DROP TABLE t1;
56 affected rows: 0
57 SET GLOBAL innodb_instant_alter_column_allowed=@save_allowed;