Bug #20616 drop_temp_table test fails on Windows platform
Submitted: 21 Jun 2006 22:32 Modified: 3 Jul 2006 20:18
Reporter: Iggy Galarza Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S2 (Serious)
Version:5.0.23 OS:
Assigned to: Iggy Galarza

[21 Jun 2006 22:32] Iggy Galarza
Description:
The drop_temp_table test has been failing on Windows platforms since June 5th.

How to repeat:
Download the latest 5.0 bk repository.  
Attempt 
./mysql-test-run.pl --do-test=drop_temp_table

on a Windows machine.
[22 Jun 2006 14:43] Miguel Solorzano
Thank you for the bug report.

miguel@light ~/mysql-5.0.23/mysql-test
$ ./mysql-test-run.pl --do-test=drop_temp_table
Skipping ndbcluster, mysqld not compiled with ndbcluster
Setting mysqld to support SSL connections
Using MTR_BUILD_THREAD = 0
Using MASTER_MYPORT    = 9306
Using MASTER_MYPORT1   = 9307
Using SLAVE_MYPORT     = 9308
Using SLAVE_MYPORT1    = 9309
Using SLAVE_MYPORT2    = 9310
Using NDBCLUSTER_PORT  = 9350
Using IM_PORT          = 9310
Using IM_MYSQLD1_PORT  = 9312
Using IM_MYSQLD2_PORT  = 9314
Killing Possible Leftover Processes
Removing Stale Files
Installing Master Database
Installing Master Database
=======================================================
Finding  Tests in the 'main' suite
Starting Tests in the 'main' suite

TEST                           RESULT
-------------------------------------------------------

drop_temp_table                [ fail ]

Errors are (from C:/cygwin/home/miguel/mysql-5.0.23/mysql-test/var/log/mysqlt
-time) :
mysqltest: At line 15: query 'create temporary table `table:name` (a int)' fa
d: 1103: Incorrect table name 'table:name'
(the last lines may be the most important ones)
Result from queries before failure can be found in r/drop_temp_table.log

Aborting: drop_temp_table failed in default mode. To continue, re-run with '-
rce'.
Ending Tests
Shutting-down MySQL daemon

Master(s) shutdown finished
Slave(s) shutdown finished

miguel@light ~/mysql-5.0.23/mysql-test
$
[23 Jun 2006 16:15] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/8151
[3 Jul 2006 20:18] Paul Dubois
Noted in 5.0.23 changelog.

On Windows, temporary tables containing ':' in the name could not be
created.