| 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; |