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
• Status: Closed
• Category: Server: Errors
• Severity: S3 (Non-critical)
• Version: 5.1.30
• OS: Any
• Assigned to: Davi Arnaut
• Target Version: 5.1+
• Triage: Triaged: D4 (Minor)

[29 Nov 2008 9:00] Shane Bester

Description:
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.