MySQL Bugs: #31178: udf error does not stop replication

Bug #31178	udf error does not stop replication
Submitted:	24 Sep 2007 18:48	Modified:	26 Oct 2007 8:06
Reporter:	Jon Wagoner	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S2 (Serious)
Version:	4.1.22	OS:	Linux (Gentoo)
Assigned to:		CPU Architecture:	Any

Description:
My setup is a master main server and slave acting as a live backup.
I also use an aggregate UDF I wrote to help with some queries.
I updated the UDF with some newer code to add another arg, but forgot to update the slave.  The UDF returned an error on the slave because the arg count was wrong (returned 1 from the init function).
The problem is that replication did not stop, and nothing was logged to the error log, even though the UDF was returning an error.

How to repeat:
Create a UDF.  Make sure it throws an error on the slave, but not the master.  It will be silently skipped by the slave.

Suggested fix:
It should stop replication and log to the error log.

Thank you for a problem report. Please, send a sample code of UDF and SQL that uses it to demonstrate a problem.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".