Bug #20469 Stored procedures: statement truncated in binlog
Submitted: 14 Jun 2006 18:57 Modified: 28 Nov 2006 14:25
Reporter: Peter Gulutzan Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S3 (Non-critical)
Version:5.1.12-beta-debug OS:Linux (SUSE 10.0 / 64-bit)
Assigned to: Tatiana Azundris Nuernberg CPU Architecture:Any

[14 Jun 2006 18:57] Peter Gulutzan
Description:
I start mysqld with --binlog=FF.
I create a procedure which contains the statement
alter table tfp add partition (partition p3 values in (3));
I call the procedure.
I examine the binlog with mysqlbinlog.
I see that the logged statement is
alter table tfp add partition (partition p3 values in (3);
The final ')' is missing.
This caused replication failure.

How to repeat:
/* Start mysqld with --log-bin=FF */

mysql> create table tfp (s1 int) partition by list (s1) (partition p1 values in (1));
Query OK, 0 rows affected (0.03 sec)

mysql> create procedure pfp () alter table tfp add partition (partition p3 values in (3));
Query OK, 0 rows affected (0.01 sec)

mysql> call pfp();
Query OK, 0 rows affected (0.03 sec)

...

Use mysqlbinlog FF.000001 to see results.
You should see a line that looks like this:
alter table tfp add partition (partition p3 values in (3);
[14 Jun 2006 19:44] MySQL Verification Team
Thank you for the bug report. Verified on Suse 10.
[28 Nov 2006 14:25] Tatiana Azundris Nuernberg
I show

  alter table tfp add partition (partition p3 values in (3));

in 5.1.13-beta (maint) and 5.1.14-beta (main).

Considered "fixed in repo"; pls reopen this ticket if you disagree.
thanks, -A-