Bug #17549 | can't manipulate table from within it's own trigger | ||
---|---|---|---|
Submitted: | 19 Feb 2006 0:57 | Modified: | 19 Feb 2006 10:47 |
Reporter: | Roland Volkmann | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.18-nt | OS: | Windows (WinXP Prof.) |
Assigned to: | CPU Architecture: | Any |
[19 Feb 2006 0:57]
Roland Volkmann
[19 Feb 2006 10:47]
Valeriy Kravchuk
Thank you for a problem report. Sorry, but changes to the table that FOR EACH ROW trigger is created on are not allowed (and, I hope, will never be supported). Period. Partially, the reason can be found in the manual: http://dev.mysql.com/doc/refman/5.0/en/subquery-restrictions.html: "In general, you cannot modify a table and select from the same table in a subquery." But it is obviously should not be allowed.