Bug #68303 Modifying a text field from data view generates invalid SQL
Submitted: 7 Feb 2013 16:44 Modified: 7 Mar 2013 18:38
Reporter: Javier Ortiz Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.46 OS:Windows
Assigned to: CPU Architecture:Any

[7 Feb 2013 16:44] Javier Ortiz
Description:
I make a query to obtain some records from database, one of those a text column. I modify the text value column and select apply. The generated query is missing the part after the where clause.

For example: 

UPDATE `validation_manager`.`requirement` SET `description`='The software shall only produce a touch screen event when the same button is pressed then released so if you press a button, drag your finger off to another button, then release, nothing will happen' WHERE ;

How to repeat:
I make a query to obtain some records from database, one of those a text column. I modify the text value column and select apply. The generated query is missing the part after the where clause.
[7 Feb 2013 16:46] Javier Ortiz
The issue was not having the row id in the current query. Adding it to the query fixed the issue.

Still is a valid scenario.
[7 Feb 2013 18:38] MySQL Verification Team
Thank you for the bug report. Please provide the complete test case: MySQL Server version, create table statement, insert data, update data. Thanks.
[8 Mar 2013 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".