MySQL Bugs: #16198: Index type not taken into account while editing a table

Bug #16198	Index type not taken into account while editing a table
Submitted:	4 Jan 2006 16:55	Modified:	23 Oct 2006 14:09
Reporter:	Thomas CORBIERE	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.18	OS:	Windows (Windows XP)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any
Tags:	Object Editors

Description:
While adding or modifying an index for a memory table with the MySQL table editor, you cannot change the index type (Hash or BTREE).

With MySQL 5.0.18, the index type box is disabled.
With MySQL 4.1.16, the index type box is enabled but does nothing.

How to repeat:
Open the table editor, create a memory table and try to create a BTREE index on a column.

Suggested fix:
MySQL 4.1.16 : Query Browser should take into account which index type was selected.
MySQL 5.0.18 : Enable the box and make it work too

Thank you for a bug report. Verified just as described with 1.1.18 connecting to 5.0.15-nt - the combo box is disabled as soon as you try to add new index for the following table:

CREATE TABLE lookup (id INT) ENGINE = MEMORY;

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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html