Debian Codegraph @

mysql-test/suite/gcol/t/innodb_virtual_rebuild.test

raw
1 --source include/have_innodb.inc
2 --source include/have_debug.inc
3 --source include/have_debug_sync.inc
4
5 CREATE TABLE t1 (j SERIAL, i INT, v INT AS (i) VIRTUAL) ENGINE=InnoDB;
6 CREATE TABLE t2 (j SERIAL, i INT, v INT AS (i) VIRTUAL) ENGINE=InnoDB
7 ROW_FORMAT=REDUNDANT;
8 CREATE TABLE t3 (i INT, v INT AS (i) VIRTUAL) ENGINE=InnoDB;
9 CREATE TABLE t4 (i INT, v INT AS (i) VIRTUAL) ENGINE=InnoDB
10 ROW_FORMAT=REDUNDANT;
11
12 let $n=4;
13 while ($n)
14 {
15 eval INSERT INTO t$n SET i=1;
16 eval ALTER TABLE t$n ADD INDEX(v), LOCK=NONE;
17 # MDEV-17468 FIXME: Fix this, and remove the 2 --error below.
18 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
19 eval ALTER TABLE t$n ADD COLUMN k INT, ALGORITHM=INPLACE, LOCK=NONE;
20 --error ER_CANT_DROP_FIELD_OR_KEY
21 eval ALTER TABLE t$n DROP k, ALGORITHM=INPLACE, LOCK=NONE;
22 eval ALTER TABLE t$n DROP INDEX v, LOCK=NONE;
23 dec $n;
24 }
25
26 connect (ddl,localhost,root,,test);
27 connection default;
28
29 let $n=4;
30 while ($n)
31 {
32 connection ddl;
33 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL copied WAIT_FOR dml';
34 send_eval ALTER TABLE t$n FORCE;
35
36 connection default;
37 SET DEBUG_SYNC = 'now WAIT_FOR copied';
38 BEGIN;
39 eval UPDATE t$n SET i = 0;
40 ROLLBACK;
41 SET DEBUG_SYNC = 'now SIGNAL dml';
42
43 connection ddl;
44 reap;
45 connection default;
46 eval SELECT * FROM t$n;
47 eval DROP TABLE t$n;
48 dec $n;
49 }
50 disconnect ddl;
51 SET DEBUG_SYNC = 'RESET';