Bug #27045 Wrong field selected when setting key length for index filed.
Submitted: 12 Mar 2007 12:37 Modified: 26 May 2009 13:03
Reporter: Heinz Schweitzer (Gold Quality Contributor) Email Updates:
Status: Won't fix Impact on me:
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.10 OS:Windows (XP)
Assigned to: CPU Architecture:Any

[12 Mar 2007 12:37] Heinz Schweitzer
Wrong field selected when setting key length for index filed. 

MySQL Administrator 1.2.10
MySQL Server Information
Connected to MySQL Server Instance
  Username:                root
  Hostname:                localhost
  Port:                    3306
Server Information
  MySQL Version:           MySQL 5.0.27-community-nt via TCP/IP
  Network Name:            localhost
Client Information
  Version:                 MySQL Client Version 5.1.11
  Network Name:            xxxxxxxxxxx
  IP:                      xxxxxxxxxxx
  Operating System:        Windows XP
  Hardware:                2x Intel(R) Core(TM)2 CPU         T7200  @ 2.00GHz, 2.0 GB RAM

How to repeat:


	Have schema with a table defined like in screen shot k1

Open MySQL Administrator 1.2.10

From catalogs select a schema you can fool around with.

In the right pane activate the 'Schema Tables' tab and open a
table like the one mentioned above

Now select the field as shown in screen shot k1 and make a double
click in it so you see the 'Set Index ....' label.

Click on that label and the 'Index Column Length' Dialog pops up
AND  the selection jumps to next field 'c'  as shown in 
screen shot k2.

In the 'Index Column Length' Dialog enter a number an press OK
You will see that field 'c' will now have the column lenght set
like in screen shot k3

This will not happen if you start the Index Column Length' Dialog
using the black arrow at the right edge.
[12 Mar 2007 12:37] Heinz Schweitzer

Attachment: k1.jpg (image/jpeg, text), 162.08 KiB.

[12 Mar 2007 12:38] Heinz Schweitzer

Attachment: k2.jpg (image/jpeg, text), 167.68 KiB.

[12 Mar 2007 12:38] Heinz Schweitzer

Attachment: k3.jpg (image/jpeg, text), 161.36 KiB.

[12 Mar 2007 14:17] MySQL Verification Team
Thank you for the bug report.
[26 May 2009 13:03] Susanne Ebrecht
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. We won't add this feature request anymore.

More informations about MySQL Workbench you will find here: