Bug #2610 create procedure not replicated

Description:
create procedure is not replicated.

How to repeat:
Run the following two SQL statements on the replication master:

create table testtable
(
        id      INT
);
                                                                                                                                                  
create procedure testproc ()
insert into testtable (id) values (123456);

Table is created on master and all slaves but procedure is created
only on the master and not on the slaves.

Verified against the current 5.0 development tree.

CREATE/DROP PROCEDURE statements are not written to the binlog (so cannot be replicated).

Too hard and imperfect with statement-level binary logging of 5.0. Will be fixed in 5.1 with record-level binary logging.

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/internals/24177

Finally, fixed it in 5.0.5. But there will be caveats with that until 5.1, I'll document them.

Will talk with Paul about documentation of this bugfix.

Noted in 5.0.5 changelog. Bug report remains
in Documenting state pending additional
documentation.

Changelog entry has been moved to 5.0.6.

Stored routine logging now is documented at:

http://dev.mysql.com/doc/mysql/en/stored-procedure-logging.html