summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorElena Stepanova <elenst@montyprogram.com>2017-01-04 03:33:39 +0200
committerElena Stepanova <elenst@montyprogram.com>2017-01-04 03:33:39 +0200
commit0912fbbce179cba38bd41de797ba5934e63dbaad (patch)
treede4d5c1344601852a173c7133c259644895299b2
parent2718225b2626eeb8df9ab71547a81e43104d52ab (diff)
downloadmariadb-git-0912fbbce179cba38bd41de797ba5934e63dbaad.tar.gz
MDEV-11719 main.subselect_no_exists_to_in failed in buildbot
main.log_slow might leave mysql.slow_log table non-empty, and tests which later use it might fail. Make sure that the table is properly truncated
-rw-r--r--mysql-test/r/log_slow.result2
-rw-r--r--mysql-test/t/log_slow.test2
2 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/log_slow.result b/mysql-test/r/log_slow.result
index 89846dc698c..b396de8a3d8 100644
--- a/mysql-test/r/log_slow.result
+++ b/mysql-test/r/log_slow.result
@@ -67,9 +67,9 @@ sleep(0.5)
select count(*) FROM mysql.slow_log;
count(*)
1
-truncate mysql.slow_log;
set @@long_query_time=default;
set global slow_query_log= @org_slow_query_log;
set @@log_slow_filter=default;
set @@log_slow_verbosity=default;
set global log_output= default;
+truncate mysql.slow_log;
diff --git a/mysql-test/t/log_slow.test b/mysql-test/t/log_slow.test
index 8d5a09d7a94..56e35bd5a20 100644
--- a/mysql-test/t/log_slow.test
+++ b/mysql-test/t/log_slow.test
@@ -50,7 +50,6 @@ 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;
@@ -58,3 +57,4 @@ set global slow_query_log= @org_slow_query_log;
set @@log_slow_filter=default;
set @@log_slow_verbosity=default;
set global log_output= default;
+truncate mysql.slow_log;