From 386411b5baeb011edec24246d655f28c57905fd5 Mon Sep 17 00:00:00 2001 From: "monty@narttu.mysql.fi" <> Date: Wed, 19 Mar 2003 00:45:44 +0200 Subject: Allow optimzation of multi-table-update also for InnoDB tables MEMORY is alias for HEAP for CREATE TABLE ... TYPE=HEAP Fixed bug in multi-table-update where a row could be updated several times --- mysql-test/t/heap.test | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test/t/heap.test') diff --git a/mysql-test/t/heap.test b/mysql-test/t/heap.test index ef7e3239a96..d1e647ae182 100644 --- a/mysql-test/t/heap.test +++ b/mysql-test/t/heap.test @@ -17,7 +17,7 @@ select * from t1; alter table t1 add c int not null, add key (c,a); drop table t1; -create table t1 (a int not null,b int not null, primary key (a)) type=heap comment="testing heaps"; +create table t1 (a int not null,b int not null, primary key (a)) type=memory comment="testing heaps"; insert into t1 values(1,1),(2,2),(3,3),(4,4); delete from t1 where a > 0; select * from t1; -- cgit v1.2.1