function calls in select statements are not replicated
Bug #904606 reported by
Seppo Jaakola
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Fix Released
|
High
|
Seppo Jaakola | ||
5.1 |
Fix Released
|
High
|
Seppo Jaakola | ||
5.5 |
Fix Released
|
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);
To post a comment you must log in.
a fix pushed in wsrep-5.5: http:// bazaar. launchpad. net/~codership/ codership- mysql/wsrep- 5.5/revision/ 3650