Bug #26092 QueryBrowser does not allow result set editing

• Submitted: 5 Feb 2007 18:18
• Modified: 15 Feb 2007 11:37
• Reporter: Todd Farmer (OCA)
• Status: Closed
• Category: MySQL Query Browser
• Severity: S2 (Serious)
• Version: 1.2.9rc
• OS: Linux (SUSE Linux 10.1)
• CPU Architecture: Any
• Tags: bfsm_2007_02_15

[5 Feb 2007 18:18] Todd Farmer

Description:
MySQL Query Browser 1.2.9rc on Linux does not allow result set editing.  The "Start Editing" button remains disabled/greyed out after the following:

CREATE TABLE test.qb_edit_test (id INT PRIMARY KEY, name VARCHAR(10)) ENGINE=MyISAM;

INSERT INTO test.qb_edit_test VALUES (1, 'todd'), (2, 'farmer');

SELECT * FROM test.qb_edit_test;

How to repeat:
Create a table with a primary key.  Insert a row.  Execute SELECT * FROM table and try to edit result set.

Suggested fix:
Enable result set editing.

[15 Feb 2007 11:37] Alfredo Kojima

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

GUI tools 5.0-r10 should have this problem fixed.