Debian Codegraph @

mysql-test/suite/innodb/t/virtual_fk_restart.test

raw
1
2 --echo #
3 --echo # Bug#22469130: FOREIGN KEY ON DELETE CASCADE NOT ALLOWED
4 --echo # WHEN A VIRTUAL INDEX EXISTS.
5
6 --echo # Add the VIRTUAL INDEX contains fk constraINT column
7 --echo # using INPLACE alter operatiON
8 CREATE TABLE t1(fld1 INT NOT NULL PRIMARY KEY);
9 CREATE TABLE t2(fld1 INT NOT NULL, fld2 INT NOT NULL,
10 fld3 INT AS (fld2) VIRTUAL, KEY(fld1),
11 FOREIGN KEY(fld1) REFERENCES t1(fld1) ON UPDATE CASCADE);
12 INSERT INTO t1(fld1) VALUES(1);
13 INSERT INTO t2(fld1, fld2) VALUES(1, 2);
14 --source include/restart_mysqld.inc
15 UPDATE t1 SET fld1= 2;
16 SELECT fld3, fld1 FROM t2;
17 alter TABLE t2 ADD INDEX vk(fld3, fld1), ALGORITHM=INPLACE;
18 UPDATE t1 SET fld1=3;
19 SELECT fld3, fld1 FROM t2;
20 --disable_warnings
21 --replace_column 1 x 2 x 4 x 6 x 8 x 9 x 10 x 11 x 12 x
22 EXPLAIN SELECT fld3, fld1 FROM t2;
23 --enable_warnings
24 DROP TABLE t2, t1;
25
26 --echo # TEMPORARY TABLE NAME and CHILD TABLE NAME are same
27 CREATE TABLE t1(fld1 INT NOT NULL PRIMARY KEY);
28 CREATE TABLE t2(fld1 INT NOT NULL,
29 fld2 INT AS (fld1) VIRTUAL,
30 KEY(fld2),
31 FOREIGN KEY(fld1) REFERENCES t1(fld1)
32 ON UPDATE CASCADE);
33 INSERT INTO t1 VALUES(1), (2);
34 INSERT INTO t2 VALUES(1, DEFAULT), (2, default);
35 --SOURCE include/restart_mysqld.inc
36 CREATE TEMPORARY TABLE t2 (fld1 INT NOT NULL)ENGINE=INNODB;
37 UPDATE t1 SET fld1= 3 WHERE fld1= 2;
38 --connect(con1,localhost,root,,test)
39 SELECT fld2 FROM t2;
40 --disable_warnings
41 --replace_column 1 x 2 x 4 x 6 x 8 x 9 x 10 x 11 x 12 x
42 EXPLAIN SELECT fld2 FROM t2;
43 --enable_warnings
44 CHECK TABLE t2;
45 connection default;
46 disconnect con1;
47 DROP TABLE t2;
48 DROP TABLE t2, t1;