From 712b9b00fb0820b8fa4d674373109151a87c2430 Mon Sep 17 00:00:00 2001 From: unknown Date: Wed, 5 Sep 2007 12:14:43 -0600 Subject: Test events_logs_tests cleanup Fixed test failure under heavy load, in case truncate table is slow. mysql-test/r/events_logs_tests.result: Fixed test failure under heavy load, in case truncate table is slow. mysql-test/t/events_logs_tests.test: Fixed test failure under heavy load, in case truncate table is slow. --- mysql-test/t/events_logs_tests.test | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'mysql-test/t/events_logs_tests.test') diff --git a/mysql-test/t/events_logs_tests.test b/mysql-test/t/events_logs_tests.test index b9ceec2ed82..3240dccbc76 100644 --- a/mysql-test/t/events_logs_tests.test +++ b/mysql-test/t/events_logs_tests.test @@ -61,7 +61,8 @@ create event ev_log_general on schedule at now() on completion not preserve --echo Nothing should be logged --echo --replace_column 1 USER_HOST -select user_host, db, sql_text from mysql.slow_log where sql_text not like 'create event%'; +select user_host, db, sql_text from mysql.slow_log + where sql_text like 'select \'events_logs_test\'%'; set @@global.long_query_time=1; truncate mysql.slow_log; create event ev_log_general on schedule at now() on completion not preserve @@ -72,7 +73,8 @@ create event ev_log_general on schedule at now() on completion not preserve --echo Event sub-statement should be logged. --echo --replace_column 1 USER_HOST -select user_host, db, sql_text from mysql.slow_log where sql_text not like 'create event%'; +select user_host, db, sql_text from mysql.slow_log + where sql_text like 'select \'events_logs_test\'%'; drop database events_test; set global event_scheduler=off; -- cgit v1.2.1