MySQL Bugs: #27045: Wrong field selected when setting key length for index filed.

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:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.10	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any

Description:
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
  IP:                      127.0.0.1
--------------------------------------------------------------------------------
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:

Prerequisite:

	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

NOTE:
This will not happen if you start the Index Column Length' Dialog
using the black arrow at the right edge.

k1

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

k2

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

k3

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

Thank you for the bug report.

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:

http://dev.mysql.com/workbench/