Bug #18847 Adding indexes in edit table has odd behaviour
Submitted: 6 Apr 2006 13:05 Modified: 20 Dec 2006 8:02
Reporter: Csaba Skultety Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.20 OS:Windows (Win2K w/ SP4)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: Object Editors

[6 Apr 2006 13:05] Csaba Skultety 
Description:
If you add an index in edit table and apply changes, then without closing the edit table you add another index and hit apply changes, the resulting SQL statement is to drop the index that was created with the previous apply changes and recreate it along with the new index being added

How to repeat:
-Open edit table on a table with at least 2 fields
-Add an index on field 1
-Hit apply changes, then Execute
-Add an index on field 2
-Hit apply changes

You should see what I'm talking about in the SQL statement
[6 Apr 2006 16:34] MySQL Verification Team 
Thank you for the bug report.
[20 Dec 2006 8:02] Mike Lischke 
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/