Description:
The test 'events_logs_tests' is randomly failing on
different platforms with
-------------------------------------------------------
*** r/events_logs_tests.result Sat Apr 8 06:04:12 2006
--- r/events_logs_tests.reject Sun Apr 9 06:18:44 2006
***************
*** 43,49 ****
0
SELECT user_host, query_time, db, sql_text FROM mysql.slow_log;
user_host query_time db sql_text
! root[root] @ localhost [] 00:00:03 events_test SELECT SLEEP(3)
TRUNCATE mysql.slow_log;
CREATE TABLE slow_event_test (slo_val tinyint, val tinyint);
"This won't go to the slow log"
--- 43,49 ----
0
SELECT user_host, query_time, db, sql_text FROM mysql.slow_log;
user_host query_time db sql_text
! root[root] @ localhost [] 00:00:04 events_test SELECT SLEEP(3)
TRUNCATE mysql.slow_log;
CREATE TABLE slow_event_test (slo_val tinyint, val tinyint);
"This won't go to the slow log"
-------------------------------------------------------
How to repeat:
A bit hard to repeat
Suggested fix:
If really to test the delay (not sure what the test tries to do),
I would suggest to relax the matching a bit, maybe with
something like
--replace_result 00:00:03 SLEEPVAL 00:00:04 SLEEPVAL 00:00:05 SLEEPVAL
and change the result file to match SLEEPVAL. Or use the new matching
--replace_regex /00:00:0[3-5]/SLEEPVAL/