Debian Codegraph @

mysql-test/suite/innodb/r/foreign_null,COPY.rdiff

raw
1 --- foreign_null.result
2 +++ foreign_null,COPY.result
3 @@ -139,6 +139,7 @@
4 ALTER TABLE `t#2` DROP INDEX f1;
5 SET FOREIGN_KEY_CHECKS=1;
6 ALTER TABLE `t#1` MODIFY COLUMN f2 INT;
7 +ERROR HY000: Error on rename of './test/#sql-alter' to './test/t@00231' (errno: 150 "Foreign key constraint is incorrectly formed")
8 DROP TABLE `t#2`, `t#1`;
9 # Drop referenced index and modify column
10 CREATE TABLE `t#1`(f1 INT, f2 INT, PRIMARY KEY(f1), KEY(f2))ENGINE=InnoDB;
11 @@ -147,6 +148,7 @@
12 ALTER TABLE `t#1` DROP INDEX f2;
13 SET FOREIGN_KEY_CHECKS=1;
14 ALTER TABLE `t#2` MODIFY COLUMN f1 INT NOT NULL;
15 +ERROR HY000: Error on rename of './test/#sql-alter' to './test/t@00232' (errno: 150 "Foreign key constraint is incorrectly formed")
16 DROP TABLE `t#2`, `t#1`;
17 # Self referential modifying column
18 CREATE TABLE t1(f1 INT, f2 INT, index(f2), foreign key(f1) references t1(f2) ON UPDATE CASCADE)engine=innodb;