Bug #3174 Catalogs/Indices shows false UNIQUE properties

• Submitted: 15 Mar 2004 5:23
• Modified: 27 Mar 2004 13:16
• Reporter: Ingo Sontowski
• Status: Duplicate
• Category: MySQL Administrator
• Severity: S3 (Non-critical)
• Version: 1.0.2b ALPHA
• OS: Windows (Win2k SP4)
• Assigned to: Assigned Account
• CPU Architecture: Any

[15 Mar 2004 5:23] Ingo Sontowski

Description:
The indices list of a database (Catalogs) shows UNIQUE when it must be a NORMAL index. (and NORMAL when it must be UNIQUE)

Also the list losts always the first element. If it sort by name you cannot see the first index of the first table.

example:

database entry
t_a_table index1
t_a_table index2
t_b_table index1
t_c_table index1

list shows
t_a_table index2
t_b_table index1
t_c_table index1

How to repeat:
go to Catalogs/<database> an call Indices

[15 Mar 2004 10:36] Ulrich Bayer

Seems to be the same as Bug #2998 but that one is actually marked as closed.

[27 Mar 2004 13:16] MySQL Verification Team

Duplicate of bug #2598.