Bug #45716 A test case for Bug#21422 is disabled in ps.test
Submitted: 24 Jun 18:43 Modified: 9 Jul 18:32
Reporter: Alexander Nozdrin
Status: Closed
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.4 OS:Any
Assigned to: Alexander Nozdrin Target Version:5.4+
Tags: disabled
Triage: Triaged: D3 (Medium)

[24 Jun 18:43] Alexander Nozdrin 
Description:
ps.test contains the following:

# Bug #21422: GRANT/REVOKE possible inside stored function, probably in a trigger
# This is disabled for now till it is resolved in 5.0
#

#create procedure proc_1() grant all on *.* to abc@host;
#drop procedure proc_1;
#delimiter |;
#--error ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG
#create function func_1() returns int begin grant all on *.* to abc@host; return 1; end|
#delimiter ;|
#prepare abc from "grant all on *.* to abc@host";
#
#create procedure proc_1() revoke all on *.* from abc@host;
#drop procedure proc_1;
#delimiter |;#--error ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG
#create function func_1() returns int begin revoke all on *.* from abc@host; return 1;
end|
#delimiter ;|
#prepare abc from "revoke all on *.* from abc@host";

How to repeat:
*
[25 Jun 15:10] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/77196

2810 Alexander Nozdrin	2009-06-25
      Fix for Bug#45716: enable a test case for Bug#21422.
[25 Jun 15:14] Alexander Nozdrin 
The patch queued into mysql-azalea-bugfixing.
[3 Jul 8:13] Bugs System 
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090702084644-k95gd2asolvz2zpu) (version
source revid:holyfoot@mysql.com-20090626091141-s0jhc72bbgyqudc3) (merge vers:
5.4.4-alpha) (pib:11)
[9 Jul 9:34] Bugs System 
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090702084644-k95gd2asolvz2zpu) (version
source revid:holyfoot@mysql.com-20090626091141-s0jhc72bbgyqudc3) (merge vers:
5.4.4-alpha) (pib:11)
[9 Jul 18:32] Paul DuBois 
Test case changes. No changelog entry needed.