bzr commit into mysql-5.1-bugteam branch (patrick.crews:2752) Bug#32667

[Patrick Crews]

#At file:///Users/pcrews/usr/local/bin/data1/work/lowercase/mysql-5.1-bugteam/ based on revid:mats@stripped

 2752 Patrick Crews	2009-02-10
      Bug#32667: lowercase_table3.test reports to error log
      
      Reordered FLUSH and DROP statements as this test was failing with the following warning:
      Warning: Table: ./test/t1 is open on delete.
      
      Also some minor cosmetic changes.
modified:
  mysql-test/r/lowercase_table3.result
  mysql-test/t/lowercase_table3.test

=== modified file 'mysql-test/r/lowercase_table3.result'
--- a/mysql-test/r/lowercase_table3.result	2008-11-14 15:36:33 +0000
+++ b/mysql-test/r/lowercase_table3.result	2009-02-10 23:06:03 +0000
@@ -1,10 +1,10 @@
-call mtr.add_suppression("Cannot find or open table test/BUG29839 from");
+call mtr.add_suppression("Cannot find or open table test/BUG29839 from .*");
 DROP TABLE IF EXISTS t1,T1;
 CREATE TABLE t1 (a int);
-SELECT * from T1;
+SELECT * FROM T1;
 a
-drop table t1;
-flush tables;
+FLUSH TABLES;
+DROP TABLE t1;
 CREATE TABLE bug29839 (a int) ENGINE=INNODB;
 SELECT * from BUG29839;
 ERROR 42S02: Table 'test.BUG29839' doesn't exist

=== modified file 'mysql-test/t/lowercase_table3.test'
--- a/mysql-test/t/lowercase_table3.test	2008-10-13 18:33:08 +0000
+++ b/mysql-test/t/lowercase_table3.test	2009-02-10 23:06:03 +0000
@@ -9,7 +9,7 @@
 --source include/have_case_insensitive_file_system.inc
 --source include/not_windows.inc
 
-call mtr.add_suppression("Cannot find or open table test/BUG29839 from");
+call mtr.add_suppression("Cannot find or open table test/BUG29839 from .*");
 
 --disable_warnings
 DROP TABLE IF EXISTS t1,T1;
@@ -18,11 +18,10 @@ DROP TABLE IF EXISTS t1,T1;
 #
 # This is actually an error, but ok as the user has forced this
 # by using --lower-case-table-names=0
-
 CREATE TABLE t1 (a int);
-SELECT * from T1;
-drop table t1;
-flush tables;
+SELECT * FROM T1;
+FLUSH TABLES;
+DROP TABLE t1;
 
 #
 # InnoDB should in this case be case sensitive
@@ -31,7 +30,7 @@ flush tables;
 #
 
 CREATE TABLE bug29839 (a int) ENGINE=INNODB;
---error 1146
+--error ER_NO_SUCH_TABLE
 SELECT * from BUG29839;
 drop table bug29839;