summaryrefslogtreecommitdiff
path: root/mysql-test/t/multi_update.test
diff options
context:
space:
mode:
authorunknown <Sinisa@sinisa.nasamreza.org>2002-06-11 22:45:51 +0300
committerunknown <Sinisa@sinisa.nasamreza.org>2002-06-11 22:45:51 +0300
commitbf95234b05d479edc481445a175db959e6cba6f2 (patch)
tree486244434432866056db35237ee164d19478a16d /mysql-test/t/multi_update.test
parent70aa7424c41c45a8fb171bbdd9e24d74b70a7765 (diff)
downloadmariadb-git-bf95234b05d479edc481445a175db959e6cba6f2.tar.gz
A fix for multi-table delete with tables optimised away.
Still not able to make a proper test case as this crashes on files where key and data pointers are 4 bytes each. Possibly a proper test case would require myisampack. sql/sql_lex.cc: Just in case ...
Diffstat (limited to 'mysql-test/t/multi_update.test')
-rw-r--r--mysql-test/t/multi_update.test8
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/t/multi_update.test b/mysql-test/t/multi_update.test
index 0c906e56230..dc4d444d463 100644
--- a/mysql-test/t/multi_update.test
+++ b/mysql-test/t/multi_update.test
@@ -62,14 +62,14 @@ select count(*) from t2 where id2;
select count(*) from t3 where id3;
drop table t1,t2,t3;
-create table t1(id1 int not null auto_increment primary key, t varchar(100));
-create table t2(id2 int not null, t varchar(100), index(id2));
+create table t1(id1 int not null primary key, t varchar(100)) pack_keys = 1;
+create table t2(id2 int not null, t varchar(100), index(id2)) pack_keys = 1;
disable_query_log;
let $1 = 1000;
while ($1)
{
let $2 = 5;
- eval insert into t1(t) values ('aaaaaaaaaaaaaaaaaaaa');
+ eval insert into t1 values ($1,'aaaaaaaaaaaaaaaaaaaa');
while ($2)
{
eval insert into t2(id2,t) values ($1,'bbbbbbbbbbbbbbbbb');
@@ -78,5 +78,5 @@ while ($1)
dec $1;
}
enable_query_log;
-delete t1, t2 from t2,t1 where t1.id1 = t2.id2 and t1.id1 > 100;
+delete t1 from t1,t2 where t1.id1 = t2.id2 and t1.id1 > 500;
drop table t1,t2;