MySQL Bugs: #2406: cannot edit fields in a simple select query

Bug #2406	cannot edit fields in a simple select query
Submitted:	15 Jan 2004 11:41	Modified:	12 Jan 2005 18:24
Reporter:	Justin Watt	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQLCC	Severity:	S3 (Non-critical)
Version:	0.9.4-beta	OS:	Windows (Windows 2000)
Assigned to:	Bugs System	CPU Architecture:	Any

Description:
when you select a table, you get the results for a query "SELECT * FROM table_name;" the results of that query are editable. but if i edit that query (to rearrange the columns or sort using several columns (trying to get around bug 2404 and bug 2405), for example "SELECT field3, field2 FROM table_name ORDER BY field3, field2;" the results are NOT editable.

How to repeat:
1) run a query of the following form: "SELECT field3, field2 FROM table_name ORDER BY field3, field2;"
2) the resulting fields are not editable

Suggested fix:
the fields in the results for simple queries like the one described above should be editable.

you *can* edit the fields using the following query:

"SELECT * FROM table_name ORDER BY field3, field2;"

(which helps get around bug 2405)

Thank you for your interest in the MySQL graphical administration tools.
We recommend that you use our MySQL Administrator and MySQL Query
Browser.  The MySQLGUI and MySQL Command Center legacy products are
deprecated, and we are no longer maintaining those projects.

For more information on MySQL Administrator, see:
http://www.mysql.com/products/administrator/