Debian Codegraph @

mysql-test/suite/gcol/r/virtual_index_drop.result

raw
1 #
2 # MDEV-24971 InnoDB access freed virtual column
3 # after rollback of secondary index
4 #
5 CREATE TABLE t1(f1 INT, f2 INT AS (f1 + 2) VIRTUAL)ENGINE=InnoDB;
6 INSERT INTO t1(f1) VALUES(1), (1);
7 ALTER TABLE t1 ADD UNIQUE INDEX(f2), ALGORITHM=INPLACE, LOCK=EXCLUSIVE;
8 ERROR 23000: Duplicate entry '3' for key 'f2'
9 SHOW CREATE TABLE t1;
10 Table Create Table
11 t1 CREATE TABLE `t1` (
12 `f1` int(11) DEFAULT NULL,
13 `f2` int(11) GENERATED ALWAYS AS (`f1` + 2) VIRTUAL
14 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
15 DROP TABLE t1;
16 CREATE TABLE t1(f1 INT, f2 INT AS (f1 + 2) VIRTUAL)ENGINE=InnoDB;
17 INSERT INTO t1(f1) VALUES(1), (1);
18 ALTER TABLE t1 ADD UNIQUE INDEX(f2), ALGORITHM=INPLACE, LOCK=SHARED;
19 ERROR 23000: Duplicate entry '3' for key 'f2'
20 SHOW CREATE TABLE t1;
21 Table Create Table
22 t1 CREATE TABLE `t1` (
23 `f1` int(11) DEFAULT NULL,
24 `f2` int(11) GENERATED ALWAYS AS (`f1` + 2) VIRTUAL
25 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
26 DROP TABLE t1;
27 CREATE TABLE t1(f1 INT, f2 INT AS (f1) VIRTUAL)ENGINE=InnoDB;
28 INSERT INTO t1(f1) VALUES(1);
29 SET DEBUG_DBUG="+d,create_index_fail";
30 SET DEBUG_SYNC="innodb_inplace_alter_table_enter SIGNAL con1_go WAIT_FOR alter_signal";
31 ALTER TABLE t1 ADD COLUMN f3 INT AS (f1) VIRTUAL, ADD INDEX(f2, f3);
32 connect con1,localhost,root,,,;
33 SET DEBUG_SYNC="now WAIT_FOR con1_go";
34 BEGIN;
35 SELECT * FROM t1;
36 f1 f2
37 1 1
38 SET DEBUG_SYNC="now SIGNAL alter_signal";
39 connection default;
40 ERROR 23000: Duplicate entry '' for key '*UNKNOWN*'
41 connection con1;
42 rollback;
43 connection default;
44 SHOW CREATE TABLE t1;
45 Table Create Table
46 t1 CREATE TABLE `t1` (
47 `f1` int(11) DEFAULT NULL,
48 `f2` int(11) GENERATED ALWAYS AS (`f1`) VIRTUAL
49 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
50 DROP TABLE t1;
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 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 23000: Duplicate entry '' for key '*UNKNOWN*'
63 connection con1;
64 rollback;
65 connection default;
66 disconnect con1;
67 DROP TABLE t1;
68 CREATE TABLE t1(f1 CHAR(100), f2 CHAR(100) as (f1) VIRTUAL)ENGINE=InnoDB;
69 ALTER TABLE t1 ADD COLUMN f3 CHAR(100) AS (f2) VIRTUAL, ADD INDEX(f3(10), f1, f3(12));
70 ERROR 42S21: Duplicate column name 'f3'
71 DROP TABLE t1;
72 SET DEBUG_SYNC=RESET;