summaryrefslogtreecommitdiff
path: root/mysql-test/t/multi_update.test
diff options
context:
space:
mode:
authorunknown <Sinisa@sinisa.nasamreza.org>2001-06-16 14:06:54 +0300
committerunknown <Sinisa@sinisa.nasamreza.org>2001-06-16 14:06:54 +0300
commitcded0f915d7a5cd7677a460743f51a264580a7e3 (patch)
treef9ad1e23d7167c00131e94aa45af714642b12777 /mysql-test/t/multi_update.test
parent01dc56a5447d8f21224304f8370aee6f41de6160 (diff)
parentf38e23207e9e876a449300f19139d5d30972ff1f (diff)
downloadmariadb-git-cded0f915d7a5cd7677a460743f51a264580a7e3.tar.gz
bk resolve changes
sql/sql_class.h: Auto merged sql/sql_parse.cc: Auto merged sql/sql_delete.cc: Same as above
Diffstat (limited to 'mysql-test/t/multi_update.test')
-rw-r--r--mysql-test/t/multi_update.test31
1 files changed, 20 insertions, 11 deletions
diff --git a/mysql-test/t/multi_update.test b/mysql-test/t/multi_update.test
index a1ebc64504f..2b7c8587dc4 100644
--- a/mysql-test/t/multi_update.test
+++ b/mysql-test/t/multi_update.test
@@ -2,25 +2,34 @@ drop table if exists t1,t2,t3;
create table t1(id1 int not null auto_increment primary key, t char(12));
create table t2(id2 int not null, t char(12), index(id2));
create table t3(id3 int not null, t char(12), index(id3));
-let $1 = 3;
+let $1 = 10000;
while ($1)
{
- let $2 = 3;
+ let $2 = 5;
eval insert into t1(t) values ('$1');
while ($2)
{
eval insert into t2(id2,t) values ($1,'$2');
- eval insert into t3(id3,t) values ($1,'$2');
+ let $3 = 10;
+ while ($3)
+ {
+ eval insert into t3(id3,t) values ($1,'$2');
+ dec $3;
+ }
dec $2;
}
dec $1;
}
-delete t1.*,t2.* from t1,t2 where t1.id1 = t2.id2 and t1.id1 = 3;
-delete t3 from t3 left join t1 on (id1=id3) where t1.id1 is null;
-delete t2 from t1,t2,t3 where id1=id2 and id2=id3 and id1=2;
-select * from t1;
-select * from t2;
-select * from t3;
-delete t1,t2 from t1,t2 where 1;
-drop table t1,t2,t3;
+delete t1.*, t2.*, t3.* from t1,t2,t3 where t1.id1 = t2.id2 and t2.id2 = t3.id3 and t1.id1 > 9500;
+
+check table t1, t2, t3;
+
+select * from t1 where id1 > 9500;
+select * from t2 where id2 > 9500;
+select * from t3 where id3 > 9500;
+
+delete t1, t2, t3 from t1,t2,t3 where t1.id1 = t2.id2 and t2.id2 = t3.id3 and t1.id1 > 500;
+select * from t1 where id1 > 500;
+select * from t2 where id2 > 500;
+select * from t3 where id3 > 500;