From d28eb772199c67b5c430fb9854f12701b980a2fb Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 24 Feb 2003 21:25:09 +0100 Subject: test updated --- mysql-test/t/innodb_handler.test | 12 +++++------- 1 file changed, 5 insertions(+), 7 deletions(-) (limited to 'mysql-test/t/innodb_handler.test') diff --git a/mysql-test/t/innodb_handler.test b/mysql-test/t/innodb_handler.test index 6b85be9c7ab..0af822334fa 100644 --- a/mysql-test/t/innodb_handler.test +++ b/mysql-test/t/innodb_handler.test @@ -62,15 +62,13 @@ handler t2 read a=(19) where b="yyy"; handler t2 read first; handler t2 read next; -# -# We alter the table even if it's still in use by to test the Innodb -# delayed-drop code. This will generate a warning in the master.err log. -# +handler t2 close; + +handler t1 open as t2; +handler t2 read first; alter table t1 type=innodb; -handler t2 read next; ---error 1064 +--error 1109 handler t2 read last; -handler t2 close; drop table if exists t1; -- cgit v1.2.1 From 11139d6f31d2a616383cbfa1d1263b01c1c18434 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 25 Feb 2003 20:37:49 +0100 Subject: fix a bug in the test --- mysql-test/t/innodb_handler.test | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'mysql-test/t/innodb_handler.test') diff --git a/mysql-test/t/innodb_handler.test b/mysql-test/t/innodb_handler.test index 0af822334fa..5483871494e 100644 --- a/mysql-test/t/innodb_handler.test +++ b/mysql-test/t/innodb_handler.test @@ -62,13 +62,15 @@ handler t2 read a=(19) where b="yyy"; handler t2 read first; handler t2 read next; +--error 1109 +handler t2 read last; handler t2 close; handler t1 open as t2; handler t2 read first; alter table t1 type=innodb; ---error 1109 -handler t2 read last; +--error 1064 +handler t2 read first; drop table if exists t1; -- cgit v1.2.1 From 49ecdaec0bb7a29108157f58b90e18234d4241d3 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 25 Feb 2003 21:20:22 +0100 Subject: fixed again --- mysql-test/t/innodb_handler.test | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'mysql-test/t/innodb_handler.test') diff --git a/mysql-test/t/innodb_handler.test b/mysql-test/t/innodb_handler.test index 5483871494e..c6448eba3ef 100644 --- a/mysql-test/t/innodb_handler.test +++ b/mysql-test/t/innodb_handler.test @@ -62,14 +62,14 @@ handler t2 read a=(19) where b="yyy"; handler t2 read first; handler t2 read next; ---error 1109 +--error 1064 handler t2 read last; handler t2 close; handler t1 open as t2; handler t2 read first; alter table t1 type=innodb; ---error 1064 +--error 1109 handler t2 read first; drop table if exists t1; -- cgit v1.2.1