Debian Codegraph @

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

raw
1 --eval SELECT * FROM $table_name;
2 --eval SHOW CREATE TABLE $table_name;
3 --eval CHECK TABLE $table_name;
4
5 --eval UPDATE $table_name SET $pk_col = 1 WHERE $sel_col = '$sel_val';
6
7 --eval SELECT * FROM $table_name;
8 --eval SHOW CREATE TABLE $table_name;
9 --eval CHECK TABLE $table_name;
10
11 connect (con1,localhost,root,,);
12
13 connection con1;
14 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
15 send;
16 eval ALTER TABLE $table_name ADD PRIMARY KEY ($pk_col);
17
18 connection default;
19 SET DEBUG_SYNC='now WAIT_FOR update_now';
20
21 eval SELECT * FROM $table_name;
22 eval SHOW CREATE TABLE $table_name;
23 eval CHECK TABLE $table_name;
24
25 eval DELETE FROM $table_name WHERE $del_col = '$del_val';
26
27 eval SELECT * FROM $table_name;
28 eval SHOW CREATE TABLE $table_name;
29 eval CHECK TABLE $table_name;
30
31 SET DEBUG_SYNC='now SIGNAL update_done';
32
33 connection con1;
34 reap;
35
36 connection default;
37 disconnect con1;
38
39 eval SELECT * FROM $table_name;
40 eval SHOW CREATE TABLE $table_name;
41 eval CHECK TABLE $table_name;
42
43 eval DROP TABLE $table_name;