MySQL Bugs: #45997: Indexes hints are wrong

Bug #45997	Indexes hints are wrong
Submitted:	7 Jul 2009 9:44	Modified:	6 Aug 2009 13:31
Reporter:	PLANTE Frédéric	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.1.16	OS:	Windows (XP SP3)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any
Tags:	CHECKED, EER, hint, INDEX

Description:
in EER diagram view, when having mouse cursor over indexes, the appearing hint is wrong.

Ex:
Table ABC(field1, field2, field3)
Field 1 is primary key
field 3 is foreign key

When over primary key index, the hint shows foreign key constraint info and vice versa. The highlighted fields are correct

How to repeat:
create two table with some fields
create foreign key relation between them
put the mouse over indexes

Thnak you for the problem report. Indeed, hints are wrong. With more columns in between PK and FK it looks like hint for the next column is shown sometimes.

add some tags

comma added to tags

I'm unable to repeat this with 5.1.16 after following provided instructions.

I am able to reproduce this on Linux

I misinterpreted the description. The bug is present in MacOS X too and has been fixed.

fix confirmed. will be in 5.1.17

An entry was added to the 5.1.17 changelog:

In the EER Diagram, when hovering the cursor over a column in a table, the hint box contained the text of the subsequent column, and the first column hint box contained the name of the table.