here goes a patch for the bug <http://bugs.mysqsl.com/21975>.
The fix suggested here is to do implicit commit with every
GRANT/REVOKE statement. It looks like being in concert with
another DDL and administrative statements behavior.
If this approach (and the patch) approved I'd also suggest to add
the following sentence to the Manual at the very end of the 3rd
paragraph of the subclause 13.4.3 "Statements That Cause an
Implicit Commit": "Beginning with MySQL 5.0.40, the GRANT and
REVOKE statements cause an implicit commit."
Great thanks to Konstantin Osipov for the hint and explanations.
In the hope it helps.
Attachment: [text/x-patch] bug21975.patch
|• [PATCH] Proposed patch for bug #21975||Vladimir Shebordaev||1 Apr|