diff options
author | unknown <malff@omega.weblab> | 2007-09-05 12:14:43 -0600 |
---|---|---|
committer | unknown <malff@omega.weblab> | 2007-09-05 12:14:43 -0600 |
commit | 712b9b00fb0820b8fa4d674373109151a87c2430 (patch) | |
tree | 20c12db18740b71ce892bd50e34f0863eff50fa7 /mysql-test/t/events_logs_tests.test | |
parent | ddf8272b756314d49065845118b322080461a2cf (diff) | |
download | mariadb-git-712b9b00fb0820b8fa4d674373109151a87c2430.tar.gz |
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.
Diffstat (limited to 'mysql-test/t/events_logs_tests.test')
-rw-r--r-- | mysql-test/t/events_logs_tests.test | 6 |
1 files changed, 4 insertions, 2 deletions
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; |