Bug #66140 1592 Unsafe statement written to the binary log using statement format

Submitted: 1 Aug 2012 11:36 Modified: 1 Sep 2012 13:37
Reporter: Mark Rouse Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:5.5.20 Server OS:Windows (Win7 64-bit)
Assigned to: CPU Architecture:Any
Tags: CURRENT_USER(), warnings

[1 Aug 2012 11:36] Mark Rouse 
Description:
I have put together a stored procedure that uses the CURRENT_USER() function in the select query (which is part of my insert into statement) and when it runs, I get the following warning:

1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave.

I don't have replication setup and not using it.  I only have 1 server.

How to repeat:
Write any stored procedure that uses the CURRENT_USER() to perhaps update a column in a specified table.
[1 Aug 2012 13:37] Valeriy Kravchuk 
Please, check if the same problem still happens with a newer version, 5.5.24 at least. If it does, please, send your my.cnf file content.
[1 Aug 2012 13:38] Valeriy Kravchuk 
Sorry, my.ini (I had not noted initially that you are on Windows).
[2 Sep 2012 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

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

Page generated in 0.050 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.