"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "mysql-test/suite/gcol/r/innodb_virtual_fk_restart.result" between
mariadb-10.2.21.tar.gz and mariadb-10.2.22.tar.gz

About: MariaDB is a relational database management system (a drop-in replacement for MySQL). Stable (GA) release (10.2).

innodb_virtual_fk_restart.result  (mariadb-10.2.21):innodb_virtual_fk_restart.result  (mariadb-10.2.22)
# #
# Bug#22469130: FOREIGN KEY ON DELETE CASCADE NOT ALLOWED # Bug#22469130: FOREIGN KEY ON DELETE CASCADE NOT ALLOWED
# WHEN A VIRTUAL INDEX EXISTS. # WHEN A VIRTUAL INDEX EXISTS.
# Add the VIRTUAL INDEX contains fk constraINT column # Add the VIRTUAL INDEX contains fk constraINT column
# using INPLACE alter operatiON # using INPLACE alter operatiON
CREATE TABLE t1(fld1 INT NOT NULL PRIMARY KEY) engine=innodb; CREATE TABLE t1(fld1 INT NOT NULL PRIMARY KEY) engine=innodb;
CREATE TABLE t2(fld1 INT NOT NULL, fld2 INT NOT NULL, CREATE TABLE t2(fld1 INT NOT NULL, fld2 INT NOT NULL,
fld3 INT AS (fld2) VIRTUAL, KEY(fld1), fld3 INT AS (fld2) VIRTUAL, KEY(fld1),
FOREIGN KEY(fld1) REFERENCES t1(fld1) ON UPDATE CASCADE) engine=innodb; FOREIGN KEY(fld1) REFERENCES t1(fld1) ON UPDATE CASCADE) engine=innodb;
CREATE TABLE u1(a INT, KEY(a)) ENGINE=InnoDB;
CREATE TABLE u2(b INT, vb INT GENERATED ALWAYS AS(b) VIRTUAL, KEY(vb),
FOREIGN KEY(b) REFERENCES u1(a)ON DELETE CASCADE)ENGINE=InnoDB;
INSERT INTO u1 SET a=1;
INSERT INTO u2 SET b=1;
INSERT INTO t1(fld1) VALUES(1); INSERT INTO t1(fld1) VALUES(1);
INSERT INTO t2(fld1, fld2) VALUES(1, 2); INSERT INTO t2(fld1, fld2) VALUES(1, 2);
UPDATE t1 SET fld1= 2; UPDATE t1 SET fld1= 2;
DELETE FROM u1;
SELECT * FROM u2;
b vb
DROP TABLE u2,u1;
SELECT fld3, fld1 FROM t2; SELECT fld3, fld1 FROM t2;
fld3 fld1 fld3 fld1
2 2 2 2
alter TABLE t2 ADD INDEX vk(fld3, fld1), ALGORITHM=INPLACE; alter TABLE t2 ADD INDEX vk(fld3, fld1), ALGORITHM=INPLACE;
UPDATE t1 SET fld1=3; UPDATE t1 SET fld1=3;
SELECT fld3, fld1 FROM t2; SELECT fld3, fld1 FROM t2;
fld3 fld1 fld3 fld1
2 3 2 3
DROP TABLE t2, t1; DROP TABLE t2, t1;
# TEMPORARY TABLE NAME and CHILD TABLE NAME are same # TEMPORARY TABLE NAME and CHILD TABLE NAME are same
 End of changes. 2 change blocks. 
0 lines changed or deleted 9 lines changed or added

Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)