MySQL Bugs: #7178: Edit remains on from query to query

Bug #7178	Edit remains on from query to query
Submitted:	10 Dec 2004 18:05	Modified:	10 Dec 2004 21:00
Reporter:	Rob Kotenko	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.1	OS:	Windows (Win 2000)
Assigned to:		CPU Architecture:	Any

Description:
After editing a single table, I opened a resultset consisting of a join of two tables.  The 'Edit' button remained active, leading me to believe that I could edit the resultset of joined tables.  In fact, right clicking on the set shows that the options available for edit are still active (ie 'Delete Row(s)').

I then tried to delete a row from this join query and it marked the row for deletion.  However, I was not allowed to click 'Apply Changes' nor 'Discard Changes' even though both were active.  I was also not allowed to turn off 'Edit'.  To the casual user, it appears that that area is frozen.

The only way to turn off 'Edit' is to run a query of one table (which prompts the query browser to ask if you would like to discard changes even though none have been made) and THEN click on 'Edit' (which prompts ANOTHER question about discarding changes.

How to repeat:
Create 2 tables with data.

Run a query of 1 table.

Click 'Edit'.

Join the 2nd table to the 1st and run the query.

Note that the Edit button is still active.

-----

If you create the join query WITHOUT doing the steps to make 'Edit' active, you will find that 'Edit' is greyed out.

Suggested fix:
Make sure edit button is not active before running a new query

Alternatively, make sure it is off for any query other than single table ones.

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 bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html