Bug #20531 Can't drop test database on Windows

• Submitted: 19 Jun 2006 11:15
• Modified: 20 Oct 2006 16:48
• Reporter: Lars Thalmann
• Status: Can't repeat
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.0 source
• OS: Windows (Windows)
• Assigned to: Iggy Galarza
• CPU Architecture: Any

[19 Jun 2006 11:15] Lars Thalmann

Description:
Adding the following line to the mysqldump test program fails 
on windows:

  drop database if exists test;

See push into MySQL 5.0 RPL team tree:
  Mon Jun 5 08:59:04 2006 grog [C=2] (1976 lines) BUG#17201

All other uses of databases in this test uses another database than
'test', but I see no reason why it should not work with 'test' too.

OS: Windows 2003 x86 -max

How to repeat:
Add the above line to mysqldump.test (or probably any other 
test script).

Suggested fix:
Check how Windows is handling rmdir

[19 Jun 2006 11:23] 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/7842

[22 Jun 2006 14:56] MySQL Verification Team

Thank you for the bug report.

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

mysqldump-max                  [ pass ]
mysqldump                      [ fail ]

Errors are (from C:/cygwin/home/miguel/mysql-5.0.23/mysql-test/var/log/mys
-time) :

[3 Aug 2006 14:12] Magnus Blåudd

Probably the rmdir can't be used to drop a diretory containing files that are in use. 

Why would you wan't to drop the test database?