Bug #17588 Problem with "drop database" in IM tests on SCO.
Submitted: 20 Feb 2006 17:11 Modified: 14 Sep 2006 19:36
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:Instance Manager Severity:S3 (Non-critical)
Version:5.1.7-beta OS:Other (SCO OSR 6)
Assigned to: Petr Chardin CPU Architecture:Any

[20 Feb 2006 17:11] Joerg Bruehe
Description:
Build of 5.1.7-beta, based on ChangeSet
  1.2139 06/02/20 00:32:07 kent@mysql.com +3 -0
  mysql-test-run.pl:
    Added --restart-cleanup option
  drop-on-restart.inc:
    DROP commands to cleanup on restart
    new file
  mysqltest.c:
    Added option --include=<sql-file>

This error occurs only in non-debug builds on SCO, OSR 6:
im_options_set                 [ fail ]

Errors are (from PATH/mysqltest-time) :
mysqltest: In included file "./include/drop-on-restart.inc": At line 8: query 'drop database if exists BANK' failed: 1149: You have an error in your command syntax. Check the manual that corresponds to your MySQL Instance Manager version for the right syntax to use
(the last lines may be the most important ones)

The same symptom comes in "im_options_unset" and "im_utils".

How to repeat:
Found by running the test suite.
[14 Sep 2006 19:36] Petr Chardin
The bug doesn't show up anymore.