Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_debug.inc
3 --source include/have_debug_sync.inc
4
5 --echo #
6 --echo # MDEV-24971 InnoDB access freed virtual column
7 --echo # after rollback of secondary index
8 --echo #
9
10 # Exclusive lock must not defer the index removal
11
12 CREATE TABLE t1(f1 INT, f2 INT AS (f1 + 2) VIRTUAL)ENGINE=InnoDB;
13 INSERT INTO t1(f1) VALUES(1), (1);
14 --error ER_DUP_ENTRY
15 ALTER TABLE t1 ADD UNIQUE INDEX(f2), ALGORITHM=INPLACE, LOCK=EXCLUSIVE;
16 SHOW CREATE TABLE t1;
17 DROP TABLE t1;
18
19 # If Shared lock and table doesn't have any other open handle
20 # then InnoDB must not defer the index removal
21
22 CREATE TABLE t1(f1 INT, f2 INT AS (f1 + 2) VIRTUAL)ENGINE=InnoDB;
23 INSERT INTO t1(f1) VALUES(1), (1);
24 --error ER_DUP_ENTRY
25 ALTER TABLE t1 ADD UNIQUE INDEX(f2), ALGORITHM=INPLACE, LOCK=SHARED;
26 SHOW CREATE TABLE t1;
27 DROP TABLE t1;
28
29 # InnoDB should store the newly dropped virtual column into
30 # new_vcol_info in index when rollback of alter happens
31
32 CREATE TABLE t1(f1 INT, f2 INT AS (f1) VIRTUAL)ENGINE=InnoDB;
33 INSERT INTO t1(f1) VALUES(1);
34 SET DEBUG_DBUG="+d,create_index_fail";
35 SET DEBUG_SYNC="innodb_inplace_alter_table_enter SIGNAL con1_go WAIT_FOR alter_signal";
36 SEND ALTER TABLE t1 ADD COLUMN f3 INT AS (f1) VIRTUAL, ADD INDEX(f2, f3);
37 connect(con1,localhost,root,,,);
38 SET DEBUG_SYNC="now WAIT_FOR con1_go";
39 BEGIN;
40 SELECT * FROM t1;
41 SET DEBUG_SYNC="now SIGNAL alter_signal";
42 connection default;
43 --error ER_DUP_ENTRY
44 reap;
45 connection con1;
46 rollback;
47 connection default;
48 SHOW CREATE TABLE t1;
49 DROP TABLE t1;
50
51 CREATE TABLE t1(f1 INT, f2 INT AS (f1) VIRTUAL)ENGINE=InnoDB;
52 INSERT INTO t1(f1) VALUES(1);
53 SET DEBUG_DBUG="+d,create_index_fail";
54 SET DEBUG_SYNC="innodb_inplace_alter_table_enter SIGNAL con1_go WAIT_FOR alter_signal";
55 send ALTER TABLE t1 ADD INDEX(f2);
56 connection con1;
57 SET DEBUG_SYNC="now WAIT_FOR con1_go";
58 BEGIN;
59 INSERT INTO t1(f1) VALUES(1);
60 SET DEBUG_SYNC="now SIGNAL alter_signal";
61 connection default;
62 --error ER_DUP_ENTRY
63 reap;
64 connection con1;
65 rollback;
66 connection default;
67 disconnect con1;
68 DROP TABLE t1;
69
70 CREATE TABLE t1(f1 CHAR(100), f2 CHAR(100) as (f1) VIRTUAL)ENGINE=InnoDB;
71 --error ER_DUP_FIELDNAME
72 ALTER TABLE t1 ADD COLUMN f3 CHAR(100) AS (f2) VIRTUAL, ADD INDEX(f3(10), f1, f3(12));
73 DROP TABLE t1;
74 SET DEBUG_SYNC=RESET;