Reported as bug #1647042 by blueyed@sf on 2007-01-29 04:42

When creating a UNIQUE key, e.g. with
ALTER TABLE t DROP INDEX idx, ADD UNIQUE idx (fld1,fld2,fld3);
silently fails, if there's a "Duplicate entry" SQL error.

HeidiSQL seems to suppress any errors when adding or modifying indexes.


**** Comment 1 by ansgarbecker@sf, 2007-01-29 05:34

Important to know that Daniel used the form for managing indexes for
altering his table and not the query-editor.


**** Comment 2 by rosenfield@sf, 2007-01-30 12:25

Similar problem reported in at least issue #1623014 (probably others).


**** Comment 3 by rosenfield@sf, 2007-02-09 08:54

The CREATE TABLE dialog also fails silently, as per issue #1623014:
http://sourceforge.net/support/tracker.php?aid=1623014


**** Comment 4 by joey_sf@sf, 2007-02-20 23:26

This was caused by unhandled exceptions in the query thread. Fixed in
r413. Errors are logged in the sql-log panel.