From 9e1ed2e4dcaed23b6acf5944c1cfa0cba66fe29d Mon Sep 17 00:00:00 2001 From: "monty@hundin.mysql.fi" <> Date: Sat, 22 Dec 2001 15:13:31 +0200 Subject: Fixed access privilege bug in query cache. Change tests to use database 'mysqltest' instead of 'foo' Add option to not print access denied messages to check_table_access() --- mysql-test/t/drop.test | 38 +++++++++++++++++++------------------- 1 file changed, 19 insertions(+), 19 deletions(-) (limited to 'mysql-test/t/drop.test') diff --git a/mysql-test/t/drop.test b/mysql-test/t/drop.test index faf0a1a31b4..c92f2b1f3b9 100644 --- a/mysql-test/t/drop.test +++ b/mysql-test/t/drop.test @@ -11,33 +11,33 @@ create table t1(n int); drop table t1; select * from t1; -#now test for a bug in drop database - it is important that the name -#of the table is the same as the name of the database - in the original -#code this triggered a bug -drop database if exists foo; -create database foo; -drop database if exists foo; -create database foo; -create table foo.foo (n int); -insert into foo.foo values (4); -select * from foo.foo; -drop database if exists foo; -create database foo; -drop database foo; +# now test for a bug in drop database - it is important that the name +# of the table is the same as the name of the database - in the original +# code this triggered a bug +drop database if exists mysqltest; +create database mysqltest; +drop database if exists mysqltest; +create database mysqltest; +create table mysqltest.mysqltest (n int); +insert into mysqltest.mysqltest values (4); +select * from mysqltest.mysqltest; +drop database if exists mysqltest; +create database mysqltest; +drop database mysqltest; # test drop/create database and FLUSH TABLES WITH READ LOCK -drop database if exists foo; +drop database if exists mysqltest; flush tables with read lock; --error 1209,1223; -create database foo; +create database mysqltest; unlock tables; -create database foo; +create database mysqltest; show databases; flush tables with read lock; --error 1208,1223; -drop database foo; +drop database mysqltest; unlock tables; -drop database foo; +drop database mysqltest; show databases; --error 1008 -drop database foo; +drop database mysqltest; -- cgit v1.2.1