From: Date: July 19 2005 10:49am
Subject: bk commit into 5.0 tree (gluh:1.1952) BUG#11577
List-Archive: http://lists.mysql.com/internals/27288
X-Bug: 11577
Message-Id: <200507190849.j6J8noa4027961@eagle.intranet.mysql.r18.ru>

Below is the list of changes that have just been committed into a local
5.0 repository of gluh. When gluh does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet
  1.1952 05/07/19 13:49:43 gluh@stripped +3 -0
  Bug#11577 'show procedure/function status' doesn't work for user with limited access
     changed 'SHOW PROCEDURE' behavoiur to be like INFORMATION_SCHEMA.routines

  sql/sql_parse.cc
    1.449 05/07/19 13:48:40 gluh@stripped +6 -4
    Bug#11577 'show procedure/function status' doesn't work for user with limited access
       changed 'SHOW PROCEDURE' behavoiur to be like INFORMATION_SCHEMA.routines

  mysql-test/t/information_schema.test
    1.43 05/07/19 13:48:40 gluh@stripped +2 -0
    Bug#11577 'show procedure/function status' doesn't work for user with limited access
       changed 'SHOW PROCEDURE' behavoiur to be like INFORMATION_SCHEMA.routines

  mysql-test/r/information_schema.result
    1.61 05/07/19 13:48:40 gluh@stripped +3 -0
    Bug#11577 'show procedure/function status' doesn't work for user with limited access
       changed 'SHOW PROCEDURE' behavoiur to be like INFORMATION_SCHEMA.routines

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	gluh
# Host:	eagle.intranet.mysql.r18.ru
# Root:	/home/gluh/MySQL/Merge/5.0

--- 1.448/sql/sql_parse.cc	Tue Jul 19 01:55:32 2005
+++ 1.449/sql/sql_parse.cc	Tue Jul 19 13:48:40 2005
@@ -2386,10 +2386,12 @@
     select_result *result=lex->result;
     if (all_tables)
     {
-      res= check_table_access(thd,
-			      lex->exchange ? SELECT_ACL | FILE_ACL :
-			      SELECT_ACL,
-			      all_tables, 0);
+      if (lex->orig_sql_command != SQLCOM_SHOW_STATUS_PROC &&
+          lex->orig_sql_command != SQLCOM_SHOW_STATUS_FUNC)
+        res= check_table_access(thd,
+                                lex->exchange ? SELECT_ACL | FILE_ACL :
+                                SELECT_ACL,
+                                all_tables, 0);
     }
     else
       res= check_access(thd,

--- 1.60/mysql-test/r/information_schema.result	Wed Jul 13 13:29:37 2005
+++ 1.61/mysql-test/r/information_schema.result	Tue Jul 19 13:48:40 2005
@@ -298,6 +298,9 @@
 Function	sql_mode	Create Function
 sub2		CREATE FUNCTION `test`.`sub2`(i int) RETURNS int(11)
 return i+1
+show function status like "sub2";
+Db	Name	Type	Definer	Modified	Created	Security_type	Comment
+test	sub2	FUNCTION	mysqltest_1@localhost	#	#	DEFINER	
 drop function sub2;
 show create procedure sel2;
 Procedure	sql_mode	Create Procedure

--- 1.42/mysql-test/t/information_schema.test	Wed Jul  6 03:24:32 2005
+++ 1.43/mysql-test/t/information_schema.test	Tue Jul 19 13:48:40 2005
@@ -157,6 +157,8 @@
 show create procedure sel2;
 show create function sub1;
 show create function sub2;
+--replace_column 5 # 6 #
+show function status like "sub2";
 connection default;
 disconnect user1;
 drop function sub2;