MySQL patches by Codership

function calls in select statements are not replicated

Bug #904606 reported by Seppo Jaakola on 2011-12-15

This bug affects 1 person

	Status	Importance	Assigned to	Milestone
MySQL patches by Codership	Fix Released	High	Seppo Jaakola	MySQL patches by Codership 5.5.20-23.4
5.1	Fix Released	High	Seppo Jaakola	MySQL patches by Codership 5.1.61-23.3
5.5	Fix Released	High	Seppo Jaakola	MySQL patches by Codership 5.5.20-23.4

Bug Description

The results of a function call will not be replicated if function is called from a select statement.
Howto reproduce:

Start two nodes, issue in node one:

CREATE TABLE test.t(i int);
DELIMITER /
CREATE FUNCTION 'test' (i INT) RETURNS INT DETERMINISTIC CONTAINS SQL
BEGIN
INSERT INTO test.t VALUES (i);
END/
DELIMITER ;

Check in both nodes:
SELECT test(1);