diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb-fk.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb-fk.result | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb-fk.result b/mysql-test/suite/innodb/r/innodb-fk.result index 0a269bad828..a7b667b3839 100644 --- a/mysql-test/suite/innodb/r/innodb-fk.result +++ b/mysql-test/suite/innodb/r/innodb-fk.result @@ -6,6 +6,7 @@ create table t1 (f1 int primary key) engine=innodb; insert into t1 values (5); insert into t1 values (2882); insert into t1 values (10); +# restart update t1 set f1 = 28 where f1 = 2882; select * from fk_120; f1 @@ -27,6 +28,7 @@ drop table t1; # Check if restrict is working fine. # create table t1 (f1 int primary key) engine=innodb; +# restart delete from t1 where f1 = 29; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`fk_29`, CONSTRAINT `pc29` FOREIGN KEY (`f1`) REFERENCES `t1` (`f1`)) select * from fk_29; |