MySQL Bugs: #26838: Key lenght could also be displayed for indices listet in 'Schema Indices'

Bug #26838	Key lenght could also be displayed for indices listet in 'Schema Indices'
Submitted:	5 Mar 2007 14:05	Modified:	28 May 2009 10:59
Reporter:	Heinz Schweitzer (Gold Quality Contributor)	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Administrator	Severity:	S4 (Feature request)
Version:	1.2.11, 1.2.9	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any
Tags:	qc

Description:
Key lenght could also be displayed for indices listet in 'Schema Indices'

MySQL Administrator 1.2.9

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 a table with an index defined using text fields 
so you have to specifie key column length

--> in screen shot i1 you see that in the table editor the key column lenght
is displayed as field-name(lenght) where in the 'Schema Inidces' tab yoo only sie field-name

Start Administrator 1.2.9
Open Catalogs
Select from Catalogs a database having a table like the one above

In the right pane select table in 'Schema Table' tab, and say edit
In this case it is the table te.
keep the Table Editor open
Now activate the 'Schema Indices' tab and open the Index using text fields
In his example PRIMARY.

--> in screen shot i1 you see that in the table editor the key column lenght
is displayed as field-name(lenght) where in the 'Schema Inidces' tab yoo only sie field-name

i1

Attachment: ScreenHunter_003.jpg (image/pjpeg, text), 158.49 KiB.

Thank you for a bug report. Verified just as described with 1.2.11.

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/