MySQL bug#11759114 - '51401: GRANT TREATS NONEXISTENT FUNCTIONS/PRIVILEGES DIFFERENTLY'

revno: 2876.425.12

committer: Dmitry Lenev <Dmitry.Lenev@oracle.com>

branch nick: mysql-trunk-11759114

timestamp: Fri 2011-04-22 16:59:10 +0400

message:

  Fix for bug#11759114 - '51401: GRANT TREATS NONEXISTENT

  FUNCTIONS/PRIVILEGES DIFFERENTLY'.

  The problem was that attempt to grant EXECUTE or ALTER

  ROUTINE privilege on stored procedure which didn't exist

  succeed instead of returning an appropriate error like

  it happens in similar situation for stored functions or

  tables.

  The code which handles granting of privileges on individual

  routine calls sp_exist_routines() function to check if routine

  exists and assumes that the 3rd parameter of the latter

  specifies whether it should check for existence of stored

  procedure or function. In practice, this parameter had

  completely different meaning and, as result, this check was

  not done properly for stored procedures.

  This fix addresses this problem by bringing sp_exist_routines()

  signature and code in line with expectation of its caller.