Debian Codegraph @

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

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