Bug #32121 "start editing" button in mysql-gui-tools no longer allows editing
Submitted: 5 Nov 2007 17:27 Modified: 8 Nov 2007 21:25
Reporter: Dan McDonald Email Updates:
Status: Closed Impact on me:
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.2.12 OS:Linux
Assigned to: CPU Architecture:Any

[5 Nov 2007 17:27] Dan McDonald
The last couple of versions of mysql-query-browser have lost the ability to edit rows.  insert and update queries can be performed on the same tables with the same tool, but the "start editing" button is always greyed out.

How to repeat:
1.  Create a new table in mysql-query-browser

create table foo (foo char(10) primary key not null, bar int(8),pef text)

2.  read the contents of the table

select * from foo

3. Notice that you can't use the "start editing" button.
4. Try to insert a record:

insert into foo set foo="foo",bar=10,pef="this is some nice text";

5. Verify it was inserted:

select * from foo;

6. Notice that the "start editing" button still fails
7. perform an update query just to prove that it works:

update foo set foo="bar"

8. Verify that it was updated:

select * from foo;

9. notice that you still can't use the "start editing" button
[7 Nov 2007 14:42] MySQL Verification Team
Thank you for the bug report. I wasn't able to repeat the behavior reported
on FC 6.0 against a 5.0 server. Are you using our binaries downloaded from
our download page?. If no could you please try?. Thanks in advance.
[7 Nov 2007 15:32] Dan McDonald
Binary packages provided by MySQL do function properly.  The binary files distributed by Mandriva fail to function properly.
[8 Nov 2007 21:21] MySQL Verification Team
Thank you for the feedback.
[8 Nov 2007 21:25] Dan McDonald
fixed by http://qa.mandriva.com/show_bug.cgi?id=33291