MySQL Forums
Forum List  »  MySQL Query Browser

Re: Does QB support UNIQUE indices?
Posted by: Mihail Lukin
Date: April 30, 2010 12:43PM

Entering & executing CREATE/ALTER TABLE works for me too, but UNIQUE option of index kind is disabled on Indices tab of Table Editor.

OK, here is my environment:
- mysql-server: 5.1.37-1ubuntu5.1
- mysql-gui-tools: 5.0r12-1ubuntu2
- interesting! UNIQUE index kind is grayed out only when MyISAM or InnoDB engine is selected! but those engines seem to support it, because entering and executing still work!
- default charset is UTF-8, but it barely matter
- index type is default, but it barely matter too
- OS is Ubuntu 9.10 amd64

Thanks, Dave!

UPD:
Look at MGTableEditor::update_for_selected_engine()
I never saw this code before, but I suggest that index "type" and "kind" could be messed up here. http://pastebin.com/asV3HJef



Edited 1 time(s). Last edit at 04/30/2010 12:43PM by Mihail Lukin.

Options: ReplyQuote


Subject
Written By
Posted
Re: Does QB support UNIQUE indices?
April 30, 2010 12:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.