Bug #59554 after executing sql snippet with order by fields are not editable
Submitted: 17 Jan 2011 14:14 Modified: 20 Jan 2011 9:10
Reporter: Christian Benner Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.31a OS:Windows (Win 7 x64 )
Assigned to: CPU Architecture:Any
Tags: workbench

[17 Jan 2011 14:14] Christian Benner
After executing a snippet as follows: 

select * from db order by <field_description>;

Fields are'nt editable. 

Opening a database and sort fields via tabs in WB allows editing field values.

How to repeat:
Open WB and select a database.
Create and save a snippet with 
select * from db order by <field to order by>;
Execute the snippet and try to edit a field value.
[18 Jan 2011 10:02] Valeriy Kravchuk
The only way to get editable grid in recent Workbench versions is to use

EDIT table_name

command (if the table has a primary key defined). This command ialso executed when you double click table in the database. Result of any SELECT, with ORDER BY or without, is NOT editable. 

Do I miss something?
[20 Jan 2011 9:10] Christian Benner
I'm so sorry. I've been working couple of years with query browser and have some ways of "how to" in blood which makes me blind for the better working paths in WB.

I thought if i've been in a table I can do everything (also editing) without any exception of how the data are queried. 

Thanks für your hint.