Bug #41121 "Statement is not safe to log in statement format" is prints table name only
Submitted: 29 Nov 2008 9:00 Modified: 18 Feb 2009 20:13
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:5.1.30 OS:Any
Assigned to: Davi Arnaut CPU Architecture:Any

[29 Nov 2008 9:00] Shane Bester
When insert delayed statements are executed with statement based binlogging enabled, you don't get the full query - only the table name.

[Warning] Statement is not safe to log in statement format. Statement: b1

Why is entire query not printed?

How to repeat:
drop table if exists b1;
create table b1(a varchar(255))engine=myisam;
insert delayed into b1 set a='test';
[16 Feb 2009 10:46] Davi Arnaut
Fixed by patch for Bug#42634
[18 Feb 2009 20:13] Paul DuBois
Noted in 5.1.32, 6.0.10 changelogs.

The server cannot execute INSERT DELAYED statements when
statement-based binary logging is enabled, but the error message 
displayed only the table name, not the entire statement.