summaryrefslogtreecommitdiff
path: root/mysql-test/t/log_slow.test
diff options
context:
space:
mode:
authorVladislav Vaintroub <wlad@montyprogram.com>2013-05-08 20:37:17 +0200
committerVladislav Vaintroub <wlad@montyprogram.com>2013-05-08 20:37:17 +0200
commitf33178b99a0b88eb513b95ac4b74ca3d3f1d70b7 (patch)
treeb2e1397fe731832327019e5951f3bfdf29f989d2 /mysql-test/t/log_slow.test
parente013bf9f0e2ffd05de5bfe95c4102e61b08ac06a (diff)
downloadmariadb-git-f33178b99a0b88eb513b95ac4b74ca3d3f1d70b7.tar.gz
MDEV-4206 : log all slow statements (do not use filters), if log_slow_filter is empty.
Diffstat (limited to 'mysql-test/t/log_slow.test')
-rw-r--r--mysql-test/t/log_slow.test13
1 files changed, 12 insertions, 1 deletions
diff --git a/mysql-test/t/log_slow.test b/mysql-test/t/log_slow.test
index af8a948d318..54f56e1bdfc 100644
--- a/mysql-test/t/log_slow.test
+++ b/mysql-test/t/log_slow.test
@@ -42,7 +42,18 @@ show fields from mysql.slow_log;
flush slow logs;
-# Reset used variables
+# MDEV-4206 (empty filter should be no filter)
+set long_query_time=0.1;
+set log_slow_filter='';
+set global slow_query_log=1;
+set global log_output='TABLE';
+select sleep(0.5);
+select count(*) FROM mysql.slow_log;
+truncate mysql.slow_log;
+
+# Reset used variables
+set @@long_query_time=default;
+set global slow_query_log=default;
set @@log_slow_filter=default;
set @@log_slow_verbosity=default;