Comment 1 for bug 1613208
Revision history for this message
| Robert Wunderer (robert-wunderer-y) wrote Re: read_only applies to users with SUPER priv as well | #1 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
67d34a1
(Get the code!)
I've found the reason for the above behavior:
The table I used in these examples has triggers with a non-SUPER user as DEFINER. So when the trigger tries to change data in an associated table, the trigger fails and the whole statement emits the above error message.
I've found this to be a general problem with triggers in MySQL: it's not clear from the error message if the original table or the trigger is causing problems.
But anyway, I think the above bug can be closed as bogus.