List:Commits« Previous MessageNext Message »
From:Sergey Glukhov Date:February 25 2009 10:20am
Subject:bzr commit into mysql-5.0-bugteam branch (Sergey.Glukhov:2762)
Bug#30305
View as plain text  
#At file:///home/gluh/MySQL/mysql-5.0-bugteam/ based on revid:kgeorge@stripped

 2762 Sergey Glukhov	2009-02-25
      Bug#30305 Create routine in wrong context in SHOW PRIVILEGES
      Changed context of Create routine to Databases.
     @ mysql-test/r/grant.result
        result fix
     @ mysql-test/r/sp.result
        result fix
     @ sql/sql_show.cc
        Changed context of Create routine to Databases.

    modified:
      mysql-test/r/grant.result
      mysql-test/r/sp.result
      sql/sql_show.cc
=== modified file 'mysql-test/r/grant.result'
--- a/mysql-test/r/grant.result	2009-02-05 20:47:23 +0000
+++ b/mysql-test/r/grant.result	2009-02-25 10:20:20 +0000
@@ -457,7 +457,7 @@ Privilege	Context	Comment
 Alter	Tables	To alter the table
 Alter routine	Functions,Procedures	To alter or drop stored functions/procedures
 Create	Databases,Tables,Indexes	To create new databases and tables
-Create routine	Functions,Procedures	To use CREATE FUNCTION/PROCEDURE
+Create routine	Databases	To use CREATE FUNCTION/PROCEDURE
 Create temporary tables	Databases	To use CREATE TEMPORARY TABLE
 Create view	Tables	To create new views
 Create user	Server Admin	To create new users

=== modified file 'mysql-test/r/sp.result'
--- a/mysql-test/r/sp.result	2009-01-28 17:59:08 +0000
+++ b/mysql-test/r/sp.result	2009-02-25 10:20:20 +0000
@@ -2475,7 +2475,7 @@ Privilege	Context	Comment
 Alter	Tables	To alter the table
 Alter routine	Functions,Procedures	To alter or drop stored functions/procedures
 Create	Databases,Tables,Indexes	To create new databases and tables
-Create routine	Functions,Procedures	To use CREATE FUNCTION/PROCEDURE
+Create routine	Databases	To use CREATE FUNCTION/PROCEDURE
 Create temporary tables	Databases	To use CREATE TEMPORARY TABLE
 Create view	Tables	To create new views
 Create user	Server Admin	To create new users
@@ -2527,7 +2527,7 @@ Privilege	Context	Comment
 Alter	Tables	To alter the table
 Alter routine	Functions,Procedures	To alter or drop stored functions/procedures
 Create	Databases,Tables,Indexes	To create new databases and tables
-Create routine	Functions,Procedures	To use CREATE FUNCTION/PROCEDURE
+Create routine	Databases	To use CREATE FUNCTION/PROCEDURE
 Create temporary tables	Databases	To use CREATE TEMPORARY TABLE
 Create view	Tables	To create new views
 Create user	Server Admin	To create new users

=== modified file 'sql/sql_show.cc'
--- a/sql/sql_show.cc	2009-02-17 14:22:48 +0000
+++ b/sql/sql_show.cc	2009-02-25 10:20:20 +0000
@@ -106,7 +106,7 @@ static struct show_privileges_st sys_pri
   {"Alter", "Tables",  "To alter the table"},
   {"Alter routine", "Functions,Procedures",  "To alter or drop stored functions/procedures"},
   {"Create", "Databases,Tables,Indexes",  "To create new databases and tables"},
-  {"Create routine","Functions,Procedures","To use CREATE FUNCTION/PROCEDURE"},
+  {"Create routine","Databases","To use CREATE FUNCTION/PROCEDURE"},
   {"Create temporary tables","Databases","To use CREATE TEMPORARY TABLE"},
   {"Create view", "Tables",  "To create new views"},
   {"Create user", "Server Admin",  "To create new users"},


Attachment: [text/bzr-bundle] bzr/sergey.glukhov@sun.com-20090225102020-gsjmt6ey6lyec9wr.bundle
Thread
bzr commit into mysql-5.0-bugteam branch (Sergey.Glukhov:2762)Bug#30305Sergey Glukhov25 Feb