Bug #16831 Problem with explain query
Submitted: 27 Jan 2006 9:22 Modified: 1 Dec 2006 14:34
Reporter: Tashinga Pemhiwa Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.17 OS:Windows (Windows XP)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: Generic

[27 Jan 2006 9:22] Tashinga Pemhiwa 
Description:
After typing an explain query, the resultset shows that the key type is a primary key yet in fact it is just a unique key. 

How to repeat:
Create a table with one of the fields defined as a unique key. Using the query browser, type Explain tablename;

The unique field appears as a primary key.

Suggested fix:
Replace the PRI with UNI.
[27 Jan 2006 17:30] Jorge del Conde 
Thanks for your bug report
[1 Sep 2006 8:40] Mike Lischke 
Tashinga, just do a double click on the table tree entry. This will insert a SELECT * from table into the query area.
[1 Dec 2006 14:34] Mike Lischke 
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/