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
