Debian Codegraph @

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

raw
1 SET GLOBAL innodb_stats_persistent = 0;
2 FLUSH TABLES;
3 #
4 # MDEV-11369: Instant ADD COLUMN for InnoDB
5 # MDEV-15562: Instant DROP COLUMN or changing the order of columns
6 #
7 connect to_be_killed, localhost, root;
8 SET @old_instant=
9 (SELECT variable_value FROM information_schema.global_status
10 WHERE variable_name = 'innodb_instant_alter_column');
11 CREATE TABLE empty (id INT PRIMARY KEY, c2 INT UNIQUE) ENGINE=InnoDB;
12 CREATE TABLE once LIKE empty;
13 CREATE TABLE twice LIKE empty;
14 CREATE TABLE thrice LIKE empty;
15 INSERT INTO once SET id=1,c2=1;
16 INSERT INTO twice SET id=1,c2=1;
17 INSERT INTO thrice SET id=1,c2=1;
18 ALTER TABLE empty ADD COLUMN (d1 INT DEFAULT 15);
19 ALTER TABLE once ADD COLUMN (d1 INT DEFAULT 20);
20 ALTER TABLE twice ADD COLUMN (d1 INT DEFAULT 20);
21 ALTER TABLE thrice ADD COLUMN (d1 INT DEFAULT 20);
22 ALTER TABLE twice ADD COLUMN
23 (d2 INT NOT NULL DEFAULT 10,
24 d3 VARCHAR(15) NOT NULL DEFAULT 'var och en char');
25 ALTER TABLE thrice ADD COLUMN
26 (d2 INT NOT NULL DEFAULT 10,
27 d3 TEXT NOT NULL DEFAULT 'con');
28 ALTER TABLE thrice DROP c2, DROP d3, CHANGE d2 d3 INT NOT NULL FIRST;
29 SELECT variable_value-@old_instant instants
30 FROM information_schema.global_status
31 WHERE variable_name = 'innodb_instant_alter_column';
32 instants
33 7
34 BEGIN;
35 INSERT INTO empty set id=0,c2=42;
36 UPDATE once set c2=c2+1;
37 UPDATE twice set c2=c2+1;
38 UPDATE thrice set d3=d3+1;
39 INSERT INTO twice SET id=2,c2=0,d3='';
40 INSERT INTO thrice SET id=2,d3=0;
41 DELETE FROM empty;
42 DELETE FROM once;
43 DELETE FROM twice;
44 DELETE FROM thrice;
45 connection default;
46 SET GLOBAL innodb_flush_log_at_trx_commit=1;
47 CREATE TABLE foo(a INT PRIMARY KEY) ENGINE=InnoDB;
48 # Kill the server
49 disconnect to_be_killed;
50 # restart
51 DROP TABLE foo;
52 InnoDB 0 transactions not purged
53 SELECT * FROM empty;
54 id c2 d1
55 SELECT * FROM once;
56 id c2 d1
57 1 1 20
58 SELECT * FROM twice;
59 id c2 d1 d2 d3
60 1 1 20 10 var och en char
61 SELECT * FROM thrice;
62 d3 id d1
63 10 1 20
64 DROP TABLE empty, once, twice, thrice;