diff options
author | unknown <monty@mashka.mysql.fi> | 2004-02-22 10:04:08 +0200 |
---|---|---|
committer | unknown <monty@mashka.mysql.fi> | 2004-02-22 10:04:08 +0200 |
commit | 54cefbab0f80629e9f29468f47664da064812c4e (patch) | |
tree | bb4a0959d03a40cc4edc02b97239c982e8b8bed3 /mysql-test/t/multi_update.test | |
parent | 192bf819eb2bb91e383327d3bde6f596c20a82db (diff) | |
parent | 2100d85c4feac93aae349ca5666e638dba3ea807 (diff) | |
download | mariadb-git-54cefbab0f80629e9f29468f47664da064812c4e.tar.gz |
Merge with 4.0 to get fixed tests
mysql-test/t/lock_tables_lost_commit.test:
Auto merged
Diffstat (limited to 'mysql-test/t/multi_update.test')
-rw-r--r-- | mysql-test/t/multi_update.test | 13 |
1 files changed, 0 insertions, 13 deletions
diff --git a/mysql-test/t/multi_update.test b/mysql-test/t/multi_update.test index 4cb6218e0c4..eb77734300f 100644 --- a/mysql-test/t/multi_update.test +++ b/mysql-test/t/multi_update.test @@ -309,19 +309,6 @@ delete t1, t2 from t2,t1 where t1.id1=t2.id2 and 0=1; drop table t1,t2; -create table `t1` (`id` int( 11 ) not null ,primary key ( `id` )) type = innodb; -insert into `t1`values ( 1 ) ; -create table `t2` (`id` int( 11 ) not null default '0',unique key `id` ( `id` ) ,constraint `t1_id_fk` foreign key ( `id` ) references `t1` (`id` )) type = innodb; -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` )) type = innodb; -insert into `t3`values ( 1 ) ; ---error 1217 -delete t3,t2,t1 from t1,t2,t3 where t1.id =1 and t2.id = t1.id and t3.id = t2.id; ---error 1217 -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; ---error 1109 -update t3 set t3.id=7 where t1.id =1 and t2.id = t1.id and t3.id = t2.id; -drop table t3,t2,t1; # # Test for bug #1820. |