Bug #24171 Primary key indicator,yellow key, no longer displayed ?
Submitted: 10 Nov 2006 8:30 Modified: 10 Nov 2006 10:59
Reporter: Heinz Schweitzer (Gold Quality Contributor) Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.5 RC OS:Windows (XP)
Assigned to: CPU Architecture:Any

[10 Nov 2006 8:30] Heinz Schweitzer 
Description:
Primary key indicator,yellow key, no longer displayed ?

The primary key indicator, yellow key is no longer displayed
in  tables, allthough there is a primary key defined.

MySQL Server Information
--------------------------------------------------------------------------------
Connected to MySQL Server Instance
  Username:                root
  Hostname:                localhost
  Port:                    3306
--------------------------------------------------------------------------------
Server Information
  MySQL Version:           MySQL 5.0.24a-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:                Intel(R) Pentium(R) M processor 1600MHz, 512 MB RAM

How to repeat:

Open MA
Select in 'Catalogs'-->'mysql'
In the reight pane edit/open table 'columns_priv'
No yellow key symbol for primary key fields see
screen shot p1

Open the same table in MySQl Query Browser  via 'Edit Table Data' .
There you have the yellow key.
see screen shot p2
[10 Nov 2006 8:31] Heinz Schweitzer 
s1

Attachment: shot_1.jpg (image/jpeg, text), 73.79 KiB.
[10 Nov 2006 8:31] Heinz Schweitzer 
p2

Attachment: shot_2.jpg (image/jpeg, text), 63.55 KiB.
[10 Nov 2006 10:57] MySQL Verification Team 
MA shows PK

Attachment: MA-PK.PNG (image/png, text), 48.17 KiB.
[10 Nov 2006 10:59] MySQL Verification Team 
Thank you for the bug report. I was unable to repeat, please see
attached screenshot. Are you changed the MA display font?
[1 Feb 2007 23:24] chris vlad 
In latest version of mysql admin the yellow primary key icon is missing when editing tables. I can confirm at list for mysql version 5.0-r8 and 5.0-r9a.
Chris V.
buburuza@yhaoo.com