Bug #4342 Dropping nonexistent index makes server hang
Submitted: 30 Jun 2004 12:49 Modified: 6 Jul 2004 10:39
Reporter: Hartmut Holzgraefe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version: OS:
Assigned to: CPU Architecture:Any

[30 Jun 2004 12:49] Hartmut Holzgraefe
Description:
Droping a nonexistent index with "ALTER TABLE DROP INDEX ..." 
gives error 1091 as expected, but droping any other index
(no matter if it exists or not) over the same connection
hangs the server.

How to repeat:
CREATE TABLE abc (i int);
ALTER TABLE abc DROP INDEX xyz;
ALTER TABLE abc DROP INDEX xyz;
[5 Jul 2004 22:09] Antony Curtis
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html