Debian Codegraph @

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

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 SET @old_instant=
3 (SELECT variable_value FROM information_schema.global_status
4 WHERE variable_name = 'innodb_instant_alter_column');
5 CREATE TABLE t(a INT PRIMARY KEY, b INT, c INT, d INT, e INT)
6 ENGINE=InnoDB;
7 INSERT INTO t VALUES(1,2,3,4,5);
8 SET innodb_strict_mode = OFF;
9 SELECT * FROM t;
10 b d a c e
11 NULL NULL 1 NULL NULL
12 ALTER TABLE t DROP b, DROP c, DROP d, DROP e,
13 ADD COLUMN b INT, ALGORITHM=INSTANT;
14 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE
15 ALTER TABLE t CHANGE COLUMN b beta INT AFTER a, ALGORITHM=INSTANT;
16 ALTER TABLE t DROP e, DROP c, DROP d, ALGORITHM=INSTANT;
17 SELECT * FROM t;
18 a beta
19 1 NULL
20 ALTER TABLE t DROP COLUMN beta, ALGORITHM=INSTANT;
21 ALTER TABLE t ADD COLUMN b INT NOT NULL, ALGORITHM=INSTANT;
22 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE
23 SELECT variable_value-@old_instant instants
24 FROM information_schema.global_status
25 WHERE variable_name = 'innodb_instant_alter_column';
26 instants
27 256
28 ALTER TABLE t ADD COLUMN b INT NOT NULL;
29 SELECT variable_value-@old_instant instants
30 FROM information_schema.global_status
31 WHERE variable_name = 'innodb_instant_alter_column';
32 instants
33 256
34 SELECT * FROM t;
35 a b
36 1 0
37 ALTER TABLE t ADD COLUMN (c CHAR(255) NOT NULL, d BIGINT NOT NULL),
38 ALGORITHM=INSTANT;
39 UPDATE t SET b=b+1,d=d+1,c='foo';
40 SELECT * FROM t;
41 a b c d
42 1 1 foo 1
43 SELECT variable_value-@old_instant instants
44 FROM information_schema.global_status
45 WHERE variable_name = 'innodb_instant_alter_column';
46 instants
47 502
48 DROP TABLE t;
49 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;