Bug #20141 User-defined variables are not replicated properly for SF/Triggers in SBR mode
Submitted: 30 May 2006 9:34 Modified: 9 Mar 2007 14:31
Reporter: Alexey Stroganov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.0.21, 5.1.9 OS:Any (All)
Assigned to: Chuck Bell CPU Architecture:Any
Tags: bfsm_2006_11_02

[30 May 2006 9:34] Alexey Stroganov
Description:
Working on replication tests I found that user-defined variables are not replicated properly for SF/Triggers in SBR mode. In RBR mode all works ok.

How to repeat:
I've attached archive with test-case and result file that need to be unpacked in mysql-test directory:

tar xzfv rpl_user_variables2.tar.gz 

after that just run mysql-test-run script

./mysql-test-run rpl_user_variables2
[30 May 2006 9:36] Alexey Stroganov
Test case and result file for reported bug

Attachment: rpl_user_variables2.tar.gz (application/x-gzip, text), 690 bytes.

[3 Jan 2007 15:52] Lars Thalmann
See also BUG#14914.
[3 Jan 2007 16:12] Lars Thalmann
Chuck, please check that this patch does not hinder any solution for
BUG#25167.
[8 Mar 2007 8:01] Andrei Elkin
fixed in 5.0.38,5.1.17-beta
[8 Mar 2007 8:06] Andrei Elkin
"fixed" above meant pushed
[9 Mar 2007 14:31] MC Brown
A note has been added to the 5.0.38 and 5.1.17 changelogs.