Bug #45716 A test case for Bug#21422 is disabled in ps.test

• Submitted: 24 Jun 2009 16:43
• Modified: 9 Jul 2009 16:32
• Reporter: Alexander Nozdrin
• Status: Closed
• Category: Tests: Server
• Severity: S3 (Non-critical)
• Version: 5.4
• OS: Any
• Assigned to: Alexander Nozdrin
• CPU Architecture: Any
• Tags: disabled

[24 Jun 2009 16: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 2009 13: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 2009 13:14] Alexander Nozdrin

The patch queued into mysql-azalea-bugfixing.

[3 Jul 2009 6:13] Bugs System

Pushed into 5.4.4-alpha (revid:[e-mail]-20090702084644-k95gd2asolvz2zpu) (version source revid:[e-mail]-20090626091141-s0jhc72bbgyqudc3) (merge vers: 5.4.4-alpha) (pib:11)

[9 Jul 2009 7:34] Bugs System

Pushed into 5.4.4-alpha (revid:[e-mail]-20090702084644-k95gd2asolvz2zpu) (version source revid:[e-mail]-20090626091141-s0jhc72bbgyqudc3) (merge vers: 5.4.4-alpha) (pib:11)

[9 Jul 2009 16:32] Paul DuBois

Test case changes. No changelog entry needed.