Debian Codegraph @

mysql-test/suite/innodb/include/instant_add_column_debug.inc

raw
1
2 connect (conn1, localhost, root,,);
3
4 connection default;
5
6 --eval CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b INT, c INT) ROW_FORMAT=$row_format;
7
8 INSERT INTO t1 VALUES(1, 1, 1), (2, 2, 2), (3, 3, 3), (6, 6, 6);
9
10 ALTER TABLE t1 ADD COLUMN d INT DEFAULT 10;
11
12 SELECT * FROM t1;
13
14 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL altered WAIT_FOR dmls_done';
15
16 --send ALTER TABLE t1 DROP COLUMN c, algorithm=inplace
17
18 connection conn1;
19
20 SET DEBUG_SYNC = 'now WAIT_FOR altered';
21
22 INSERT INTO t1(a, b, c) VALUES(7, 7, 7);
23
24 UPDATE t1 SET a = 10 WHERE a = 1;
25
26 DELETE FROM t1 WHERE a = 2;
27
28 UPDATE t1 SET c = 10 WHERE a = 3;
29
30 UPDATE t1 SET d = 20 WHERE a = 5;
31
32 UPDATE t1 SET a = 8, d = 20 WHERE a = 6;
33
34 SET DEBUG_SYNC = 'now SIGNAL dmls_done';
35
36 disconnect conn1;
37
38 connection default;
39
40 reap;
41
42 SET DEBUG_SYNC = 'RESET';
43
44 CHECK TABLE t1;
45
46 SHOW CREATE TABLE t1;
47
48 SELECT * FROM t1;
49
50 DROP TABLE t1;
51
52 #
53 # Bug#36840107 mysql crash after update inplace in instant ddl redundant table
54 #
55 --eval CREATE TABLE t1 (a INT, b INT) row_format=$row_format
56 INSERT INTO t1 VALUES(0,0);
57 ALTER TABLE t1 ADD COLUMN c varchar(25) DEFAULT NULL, ALGORITHM=INSTANT;
58 UPDATE t1 SET c="" WHERE a=0;
59 SELECT * FROM t1;
60 DROP TABLE t1;