Bug #59370 | safe_update option completely misunderstood in WB | ||
---|---|---|---|
Submitted: | 8 Jan 2011 21:03 | Modified: | 10 Mar 2011 13:09 |
Reporter: | Peter Laursen (Basic Quality Contributor) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench: SQL Editor | Severity: | S3 (Non-critical) |
Version: | 5..2.31 CE | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | qc |
[8 Jan 2011 21:03]
Peter Laursen
[8 Jan 2011 21:04]
Peter Laursen
the --safe-update option as (wrongly) defined in WB
Attachment: safe.jpg (image/jpeg, text), 72.77 KiB.
[8 Jan 2011 21:12]
Peter Laursen
Related server documentation request posted here: http://bugs.mysql.com/bug.php?id=59371
[8 Jan 2011 21:15]
Peter Laursen
I could express myself more clear: The key point is not if there is a WHERE/LIMIT clause but whether there is an index or not *if WHERE is used*. (LIMIT is clear of course)
[9 Jan 2011 10:35]
Valeriy Kravchuk
Indeed, when I checked the same bug report I had found out that WB in safe update mode does NOT allow statement like UPDATE t SET ... WHERE id = 1 if there is no key defined on id column. So, looks like option description in Preferences should be corrected.
[10 Mar 2011 13:09]
Tony Bedford
An entry has been added to the 5.2.34 changelog: The description given in the Workbench Preferences dialog for the --safe-updates option was incorrect.