diff options
| author | unknown <monty@mashka.mysql.fi> | 2004-02-22 10:58:22 +0200 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2004-02-22 10:58:22 +0200 |
| commit | c7c7cb78141f6be7a2e10e2195f4e0d1fc6ffa29 (patch) | |
| tree | 6f2ea2d88625e9ed327ca5aa00eca7e663f19123 | |
| parent | 7c67466d432877a5a01fc1b687c0cefeafadbffd (diff) | |
| download | mariadb-git-c7c7cb78141f6be7a2e10e2195f4e0d1fc6ffa29.tar.gz | |
Updated results
| -rw-r--r-- | mysql-test/r/innodb.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result index 66115c79b5f..4cec61faf0d 100644 --- a/mysql-test/r/innodb.result +++ b/mysql-test/r/innodb.result @@ -1339,11 +1339,11 @@ insert into `t2`values ( 1 ) ; create table `t3` (`id` int( 11 ) not null default '0',key `id` ( `id` ) ,constraint `t2_id_fk` foreign key ( `id` ) references `t2` (`id` )) engine = innodb; insert into `t3`values ( 1 ) ; delete t3,t2,t1 from t1,t2,t3 where t1.id =1 and t2.id = t1.id and t3.id = t2.id; -Cannot delete or update a parent row: a foreign key constraint fails +ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails update t1,t2,t3 set t3.id=5, t2.id=6, t1.id=7 where t1.id =1 and t2.id = t1.id and t3.id = t2.id; -Cannot delete or update a parent row: a foreign key constraint fails +ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails update t3 set t3.id=7 where t1.id =1 and t2.id = t1.id and t3.id = t2.id; -Unknown table 't1' in where clause +ERROR 42S02: Unknown table 't1' in where clause drop table t3,t2,t1; CREATE TABLE t1 (col1 int(1))ENGINE=InnoDB; CREATE TABLE t2 (col1 int(1),stamp TIMESTAMP,INDEX stamp_idx |