MySQL Bugs: #20616: drop_temp_table test fails on Windows platform

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:	S7 (Test Cases)
Version:	5.0.23	OS:
Assigned to:	Iggy Galarza	CPU Architecture:	Any

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.

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
$

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

Noted in 5.0.23 changelog.

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