Test failing in v5.0

[Sunny Bains]

Hi,

I download the latest bk source today from bk://mysql.bkbits.net/mysql-5.0
and one of the tests in mysql-test/ fails.

"
sp_trans                       [ pass ]            437
strict_autoinc_2innodb         [ pass ]             14
strict                         [ fail ]

Errors are (from ... 5.0/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 1160: query 'create table t2 select date from t1' failed:
1050: Table 't2' already exists
(the last lines may be the most important ones)
Result from queries before failure can be found in r/strict.log

Stopping All Servers
skipped 9 bytes from file: socket (3)
Restoring snapshot of databases
Resuming Tests

subselect2                     [ pass ]            165
"

Test t/sp_trans doesn't drop the table t2 at its conclusion. Adding
the "DROP TABLE" at the start of strict should fix it.

-------------------------------------------------------------------
--- t/strict.test.orig  2007-05-16 16:49:55.000000000 +1000
+++ t/strict.test       2007-05-16 16:49:55.000000000 +1000
@@ -8,6 +8,7 @@ select @@sql_mode;

 --disable_warnings
 DROP TABLE IF EXISTS t1;
+DROP TABLE IF EXISTS t2;
 --enable_warnings

 # Test INSERT with DATE
-------------------------------------------------------------------

The corresponding result patch is:

-------------------------------------------------------------------
*** r/strict.result     2007-04-19 10:32:36.000000000 +0300
--- r/strict.reject     2007-05-16 09:53:22.000000000 +0300
***************
*** 4,9 ****
--- 4,10 ----
  @@sql_mode

REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER
  DROP TABLE IF EXISTS t1;
+ DROP TABLE IF EXISTS t2;
  CREATE TABLE t1 (col1 date);
  INSERT INTO t1 VALUES('2004-01-01'),('2004-02-29');
  INSERT INTO t1 VALUES('0000-10-31');
-------------------------------------------------------------------

Regards,
-sunny