Bug #57333 Update all rows in table on Mac OS X causes error 1242

• Submitted: 8 Oct 2010 4:15
• Modified: 8 Oct 2010 6:11
• Reporter: Peter Dines
• Status: Not a Bug
• Category: MySQL Server: Errors
• Severity: S1 (Critical)
• Version: 5.1.51
• OS: MacOS (10.6.4)
• CPU Architecture: Any

[8 Oct 2010 4:15] Peter Dines

Description:
Running this SQL to update all rows in a table:

update [table]
  set [column] = [somevalue]

...causes this error:

Error Code: 1242
Subquery returns more than 1 row

This prevents the SQL command from executing. It happens when using both the command line client and workbench.

I tried it on a MySQL server running on Windows using the same schema and command, and it works properly.

How to repeat:
try to update all rows in a table on OS X

[8 Oct 2010 4:40] MySQL Verification Team

i wouldn't say this is a bug.  check that you don't have some incorrectly written triggers on these tables being updated?

[8 Oct 2010 6:11] Peter Dines

Oooof! You are correct. I removed the update trigger and the query worked. 

Sorry!