Bug #52969 I cannot edit the table data when a list is shown

• Submitted: 20 Apr 2010 8:00
• Modified: 20 Apr 2010 18:47
• Reporter: Anil Konsal
• Status: Won't fix
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.19 beta
• OS: Any
• CPU Architecture: Any
• Tags: regression

[20 Apr 2010 8:00] Anil Konsal

Description:
I did not find any option to edit the table data when i query the table using simple 'select *' statement, There was a way to do it in version 5.1. please see attached screen shot from version 5.1

How to repeat:
run any simple 'Select' statement on single table and then try to edit a cell value and save that value.

[20 Apr 2010 8:01] Anil Konsal

edit option in ver 5.1

Attachment: mysql_bug.png (image/png, text), 187.93 KiB.

[20 Apr 2010 9:46] Valeriy Kravchuk

Does your table have a PRIMARY KEY defined? If it does, is it selected by your SELECT statement?

[20 Apr 2010 9:52] Anil Konsal

yes, you can see the screen shot of the version 5.1. i am using the same database and same table.

[20 Apr 2010 10:57] MySQL Verification Team

Are you able to provide a dump file with table definition and some inserts commands?. Thanks in advance.

[20 Apr 2010 11:00] Valeriy Kravchuk

You are right - there is no way to edit rows in the results of even simplest SELECT * FROM table for the table with a primary key. 

As a partial workaround you can just double click on the table or issue EDIT table command in the SQL editor.

[20 Apr 2010 18:47] Johannes Taxacher

This behavior/feature has been implemented that way in Workbench intentionally.
If you want to edit table data you have to issue a specific "EDIT <tablename>" command (or select edit table data from context menus which creates the edit command for you).
This decision has been made because the auto-detection, whether a query returns an editable resultset or not, was not working properly in many cases in old Query Bowser - therefore we decided to go for a explicit edit command.