Bug #18958 Events: Test case 'events_scheduling' fails

• Submitted: 10 Apr 2006 15:03
• Modified: 11 Sep 2006 12:49
• Reporter: Kent Boortz
• Status: Can't repeat
• Category: MySQL Server: Stored Routines
• Severity: S2 (Serious)
• Version: 5.1.9-pre
• OS: Solaris (Solaris 9 x86)
• Assigned to: Andrey Hristov
• CPU Architecture: Any

[10 Apr 2006 15:03] Kent Boortz

Description:
Test case 'events_scheduling' fails with

-------------------------------------------------------
*** r/events_scheduling.result
--- r/events_scheduling.reject
***************
*** 31,37
  OK
  SELECT IF(LAST_EXECUTED-ENDS < 2, 'OK', 'ERROR') FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA=DATABASE() AND EVENT_NAME='start_n_end' AND ENDS IS NOT NULL;
  IF(LAST_EXECUTED-ENDS < 2, 'OK', 'ERROR')
! OK
  DROP EVENT start_n_end;
  "Already dropped because ended. Therefore an error."
  DROP EVENT only_one_time;
--- 31,37
  OK
  SELECT IF(LAST_EXECUTED-ENDS < 2, 'OK', 'ERROR') FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA=DATABASE() AND EVENT_NAME='start_n_end' AND ENDS IS NOT NULL;
  IF(LAST_EXECUTED-ENDS < 2, 'OK', 'ERROR')
! ERROR
  DROP EVENT start_n_end;
  "Already dropped because ended. Therefore an error."
  DROP EVENT only_one_time;
-------------------------------------------------------

How to repeat:
Could be hard to repeat, likely random