Bug #18642 edit button unavailable
Submitted: 30 Mar 2006 8:15 Modified: 20 Dec 2006 13:50
Reporter: Alexandre Chau Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.20 OS:Windows (Windows XP)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: Result Set

[30 Mar 2006 8:15] Alexandre Chau 
Description:
If a table has a name containing "union", e.g. "reunions", the edit button to modify table data is unavailable.

How to repeat:
Rename an existing table with a name containing "union" e.g. reunions (there is no bug is the table is named "union"). The table data cannot be edited in MySQL Query Browser.
[30 Mar 2006 10:31] Valeriy Kravchuk 
Thank you for a bug report. Verified just as described. Name containing "union" (also `union2`, e.g.) makes edit button unavailable, indeed.
[7 Apr 2006 12:26] Thomas Treffehn 
I have the same problem with tablenames containing underscores.
e.g. a_b
[24 Nov 2006 12:15] Max 
I have more or less the same problem, but with me it occurs with every empty table I create: with an empty table the Edit button is unavailable in the Query Browser. This makes it impossible to add data to an empty table without entering a SQL query in the SQL box.

I'm not sure whether this is related or not, so I'll post it here. If it turns out to be unrelated, I'll post a proper new bug.
[20 Dec 2006 13:50] Mike Lischke 
Alexandre:
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/

Thomas: I cannot reproduce your problem.

Max: Sounds like you don't have a primary key. Without PK you cannot edit a table since QB would not know which one to update. If this is not your problem then please open a new bug report with a reproducible test case.