Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
N/A
-
None
Description
Test case |
set @general_log.saved = @@general_log; |
set @log_output.saved = @@log_output; |
set @sql_log_off.saved = @@sql_log_off; |
|
set global general_log = 1, log_output = 'TABLE'; |
set sql_log_off = 0; |
truncate table mysql.general_log; |
select 1; |
set statement SQL_LOG_OFF = 1 for select 2; |
set SQL_LOG_OFF = 1; |
select 3; |
select * from mysql.general_log; |
|
set sql_log_off = @sql_log_off.saved; |
set global general_log = @general_log.saved; |
set global log_output = @log_output.saved; |
+----------------------------+------------------------------+-----------+-----------+--------------+--------------------------------------------+
|
| event_time | user_host | thread_id | server_id | command_type | argument |
|
+----------------------------+------------------------------+-----------+-----------+--------------+--------------------------------------------+
|
| 2014-11-01 21:23:07.658097 | root[root] @ localhost [::1] | 9 | 1 | Query | select 1 |
|
| 2014-11-01 21:23:07.851033 | root[root] @ localhost [::1] | 9 | 1 | Query | set statement SQL_LOG_OFF = 1 for select 2 |
|
| 2014-11-01 21:23:07.852758 | root[root] @ localhost [::1] | 9 | 1 | Query | set SQL_LOG_OFF = 1 |
|
+----------------------------+------------------------------+-----------+-----------+--------------+--------------------------------------------+
|
Logging to file is also affected
All the same in Percona server.