WL#8993: Option to not log in the error log when unsafe statements are executed whilst using STATEMENT based binary logging
Affects: Server-5.7
—
Status: Complete
Executive Summary ================= Option to suppress a specific warning (1592) from the server's error log file (warnings are still sent to the clients). This patch comes in as a frequently requested feature request from the community. Related to BUG#46265.
R1. By default option SHALL be ON (for retro-compatibility). R2. When option is disabled server SHALL NOT write warning 1592 to the error log. R3. Even if option is disabled, server SHALL return warning to the clients applications
The following new option is added. log_statements_unsafe_for_binlog -------------------------------- - Type: Server System Variable - Dynamic: Yes - Scope: GLOBAL - Default: ON - Valid Values: ON, OFF - Description: if option is turned OFF, then the server will not write 1592 warnings to the error log file (even though it returns them to the client applications).
Copyright (c) 2000, 2024, Oracle Corporation and/or its affiliates. All rights reserved.