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/r/events_logs_tests.result | |
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/r/events_logs_tests.result')
-rw-r--r-- | mysql-test/r/events_logs_tests.result | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/mysql-test/r/events_logs_tests.result b/mysql-test/r/events_logs_tests.result index fb658b4a83b..b7faf56f466 100644 --- a/mysql-test/r/events_logs_tests.result +++ b/mysql-test/r/events_logs_tests.result @@ -52,7 +52,8 @@ do select 'events_logs_test' as inside_event, sleep(1.5); Nothing should be logged -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\'%'; user_host db sql_text set @@global.long_query_time=1; truncate mysql.slow_log; @@ -61,7 +62,8 @@ do select 'events_logs_test' as inside_event, sleep(1.5); Event sub-statement should be logged. -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\'%'; user_host db sql_text USER_HOST events_test select 'events_logs_test' as inside_event, sleep(1.5) drop database events_test; |