summaryrefslogtreecommitdiff
path: root/mysql-test/t/multi_update.test
diff options
context:
space:
mode:
authorunknown <monty@mashka.mysql.fi>2004-02-22 09:58:51 +0200
committerunknown <monty@mashka.mysql.fi>2004-02-22 09:58:51 +0200
commit2100d85c4feac93aae349ca5666e638dba3ea807 (patch)
treed4ed5cb4cae92cde200e7cc5673b508432b875db /mysql-test/t/multi_update.test
parent522e83b64ab46d400ccb6aa8d7b749eefc28f4d5 (diff)
downloadmariadb-git-2100d85c4feac93aae349ca5666e638dba3ea807.tar.gz
Move tests that uses innodb to innodb.test
mysql-test/t/lock_tables_lost_commit.test: Ensure that innodb is compiled in
Diffstat (limited to 'mysql-test/t/multi_update.test')
-rw-r--r--mysql-test/t/multi_update.test13
1 files changed, 0 insertions, 13 deletions
diff --git a/mysql-test/t/multi_update.test b/mysql-test/t/multi_update.test
index 449d58855d9..be82870cccd 100644
--- a/mysql-test/t/multi_update.test
+++ b/mysql-test/t/multi_update.test
@@ -302,16 +302,3 @@ 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;