bk commit into 5.0 tree (cmiller:1.2626)

[Chad MILLER]

Below is the list of changes that have just been committed into a local
5.0 repository of cmiller.  When cmiller 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@stripped, 2008-05-16 11:26:29-04:00, cmiller@stripped +2 -0
  Add a test at Andrei's behest.  Show the SHOW CREATE on the
  master also, so that we can visually see the slave is the same.

  mysql-test/r/rpl_sp.result@stripped, 2008-05-16 11:26:27-04:00, cmiller@stripped +11 -0
    SHOW CREATE on master also.

  mysql-test/t/rpl_sp.test@stripped, 2008-05-16 11:26:27-04:00, cmiller@stripped +5 -0
    SHOW CREATE on master also.

diff -Nrup a/mysql-test/r/rpl_sp.result b/mysql-test/r/rpl_sp.result
--- a/mysql-test/r/rpl_sp.result	2008-05-16 09:15:55 -04:00
+++ b/mysql-test/r/rpl_sp.result	2008-05-16 11:26:27 -04:00
@@ -557,6 +557,17 @@ Procedure	sql_mode	Create Procedure
 begin
 select a;
 end
+show procedure status like '%mysqltestbug36570%';
+Db	Name	Type	Definer	Modified	Created	Security_type	Comment
+test	 mysqltestbug36570_p2	PROCEDURE	root@localhost	t	t	DEFINER	
+test	mysqltestbug36570_p1	PROCEDURE	root@localhost	t	t	DEFINER	
+show create procedure ` mysqltestbug36570_p2`;
+Procedure	sql_mode	Create Procedure
+ mysqltestbug36570_p2		CREATE DEFINER=`root`@`localhost` PROCEDURE ` mysqltestbug36570_p2`(/*!50001 a int*/)
+`label`:
+begin
+select a;
+end
 call ` mysqltestbug36570_p2`(42);
 a
 42
diff -Nrup a/mysql-test/t/rpl_sp.test b/mysql-test/t/rpl_sp.test
--- a/mysql-test/t/rpl_sp.test	2008-05-16 09:15:55 -04:00
+++ b/mysql-test/t/rpl_sp.test	2008-05-16 11:26:27 -04:00
@@ -606,8 +606,13 @@ use test|
 
 delimiter ;|
 
+--replace_column 5 t 6 t
+show procedure status like '%mysqltestbug36570%';
+show create procedure ` mysqltestbug36570_p2`;
+
 sync_slave_with_master;
 connection slave;
+
 --replace_column 5 t 6 t
 show procedure status like '%mysqltestbug36570%';
 show create procedure ` mysqltestbug36570_p2`;