Bug #44074 | Non deterministic function gives silly error message | ||
---|---|---|---|
Submitted: | 3 Apr 2009 11:52 | Modified: | 18 Jun 2012 7:35 |
Reporter: | Oli Sennhauser | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: Errors | Severity: | S3 (Non-critical) |
Version: | 5.1, 6.0 bzr | OS: | Any |
Assigned to: | Jon Olav Hauglid | CPU Architecture: | Any |
[3 Apr 2009 11:52]
Oli Sennhauser
[4 Apr 2009 18:51]
Sveta Smirnova
Thank you for the report. Verfieid as described. Test case: --source include/master-slave.inc CREATE FUNCTION hello (input CHAR(20)) RETURNS CHAR(50) NO SQL RETURN CONCAT('Hello, ', input, '!'); SELECT hello('jens'); sleep 2; connection slave; SELECT hello('jens'); Option file -slave.opt: --log-bin --log-slave-updates --log_bin_trust_function_creators=0 --binlog_format=STATEMENT
[8 Apr 2009 15:49]
Omer Barnir
This is the proper error. A non deterministic function must be logged only with RBR even if it doesn't happen to affect binlog content.
[14 Apr 2009 8:52]
Sveta Smirnova
Omer, question is why it works fine on master with same binlog_format=STATEMENT? (Which is default currently)
[14 Apr 2009 8:52]
Sveta Smirnova
So either this should fail in both cases or doesn't fail with log-slave-updates.
[7 Apr 2010 13:44]
Andrii Nikitin
isn't it a duplicate of bug 41166 (fixed in 5.1.38)
[18 Jun 2012 7:35]
Jon Olav Hauglid
Not repeatable on current trunk. No errors from master or slave.