Debian Codegraph @

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

raw
1 eval ALTER TABLE $table_name ADD $new_col INT DEFAULT 1, ALGORITHM=INSTANT;
2 eval SELECT * FROM $table_name LIMIT 15;
3
4 connect (con1,localhost,root,,);
5 connect (con2,localhost,root,,);
6
7 connection con1;
8 --echo # Prepare the new instant column
9 send;
10 eval ALTER TABLE $table_name DROP PRIMARY KEY, ADD PRIMARY KEY ($pk_col, $new_col);
11
12 connection con2;
13 --echo # Run the DML in online
14 send;
15 eval DELETE FROM $table_name WHERE $pk_col=1;
16 reap;
17
18 connection con1;
19 reap;
20
21 connection default;
22 disconnect con1;
23 disconnect con2;
24
25 eval SELECT * FROM $table_name LIMIT 15;
26 eval SHOW CREATE TABLE $table_name;
27 eval CHECK TABLE $table_name EXTENDED;
28 eval DROP TABLE $table_name;