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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.