MySQL patches by Codership

function calls in select statements are not replicated

Reported by Seppo Jaakola on 2011-12-15
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
High
Seppo Jaakola
5.1
High
Seppo Jaakola
5.5
High
Seppo Jaakola

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);

This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers