diff options
Diffstat (limited to '')
| -rw-r--r-- | mysql-test/main/log_slow_debug.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/main/log_slow_debug.result b/mysql-test/main/log_slow_debug.result index bc934c04..be825584 100644 --- a/mysql-test/main/log_slow_debug.result +++ b/mysql-test/main/log_slow_debug.result @@ -6,6 +6,8 @@ SET @@GLOBAL.log_output='TABLE'; FLUSH SLOW LOGS; SET @@GLOBAL.slow_query_log=ON; SET @@GLOBAL.log_slow_admin_statements=ON; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead SET @saved_dbug = @@debug_dbug; SET SESSION debug_dbug="+d,simulate_slow_query"; CREATE PROCEDURE show_slow_log() @@ -19,6 +21,8 @@ $$ # Expect all admin statements in the slow log (ON,DEFAULT) # SET @@SESSION.log_slow_admin_statements=ON; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead SET log_slow_filter=DEFAULT; TRUNCATE TABLE mysql.slow_log; CREATE TABLE t1 (a INT); @@ -66,6 +70,8 @@ sql_text # Expect all admin statements in the slow log (ON,admin) # SET @@SESSION.log_slow_admin_statements=ON; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead SET log_slow_filter=admin; TRUNCATE TABLE mysql.slow_log; CREATE TABLE t1 (a INT); @@ -100,6 +106,8 @@ sql_text # Expect none of admin DDL statements in the slow log (ON,filesort) # SET @@SESSION.log_slow_admin_statements=ON; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead SET log_slow_filter=filesort; TRUNCATE TABLE mysql.slow_log; CREATE TABLE t1 (a INT); @@ -127,6 +135,8 @@ sql_text # Expect none of admin statements in the slow log (OFF,DEFAULT) # SET @@SESSION.log_slow_admin_statements=OFF; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead SET log_slow_filter=DEFAULT; TRUNCATE TABLE mysql.slow_log; CREATE TABLE t1 (a INT); @@ -171,7 +181,11 @@ sql_text # prevent enabling globally suppressed logging by setting the session variable to ON. # SET @@GLOBAL.log_slow_admin_statements=OFF; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead SET @@SESSION.log_slow_admin_statements=ON; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead SET log_slow_filter=DEFAULT; TRUNCATE TABLE mysql.slow_log; CREATE TABLE t1 (a INT); @@ -311,4 +325,6 @@ TRUNCATE mysql.slow_log; SET @@global.slow_query_log= @org_slow_query_log; SET @@global.log_output= @org_log_output; SET @@global.log_slow_admin_statements= @org_log_slow_admin_statements; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead DROP PROCEDURE show_slow_log; |