Bug #57384 Safe Update Feature Fails to See Where Clause
| Submitted: | 11 Oct 2010 20:32 | Modified: | 17 Nov 2010 20:28 |
|---|---|---|---|
| Reporter: | Scott Weigand | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S3 (Non-critical) |
| Version: | 5.2.28 CE, 5.2.29 | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[11 Oct 2010 20:32]
Scott Weigand
[12 Oct 2010 6:43]
Valeriy Kravchuk
Thank you for the bug report. Looks like WHERE clause is recognized if it refers to primary key column, for example, but NOT if condition on non-indexed column is provided.
[17 Nov 2010 20:28]
Alfredo Kojima
The Safe Update feature in Workbench just enables a feature in the server. The requirement for KEY columns to be used in the WHERE statement is from the server, probably because otherwise you could still accidentally update the whole table by passing some expression that matches more rows than intended. There is nothing we can do to change that behaviour from Workbench.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.