Bug #40427 12.1.2. ALTER EVENT Syntax: Syntax error in example

• Submitted: 30 Oct 2008 12:02
• Modified: 31 Oct 2008 11:28
• Reporter: Jørgen Austvik
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: Any
• Assigned to: Jon Stephens
• CPU Architecture: Any

[30 Oct 2008 12:02] Jørgen Austvik

Description:
Here: http://dev.mysql.com/doc/refman/6.0/en/alter-event.html

Should you not add INTERVAL to this:

ALTER EVENT myevent
    ON SCHEDULE 
      EVERY 12 HOUR 
    STARTS CURRENT_TIMESTAMP + 4 HOUR;

..so that it looks like this:

ALTER EVENT myevent
    ON SCHEDULE 
      EVERY 12 HOUR 
    STARTS CURRENT_TIMESTAMP + INTERVAL 4 HOUR;

as per CREATE EVENT syntax?

(The example above gives me syntax error..)

How to repeat:
Read http://dev.mysql.com/doc/refman/6.0/en/alter-event.html :-)

Suggested fix:
ALTER EVENT myevent
    ON SCHEDULE 
      EVERY 12 HOUR 
    STARTS CURRENT_TIMESTAMP + INTERVAL 4 HOUR;

[31 Oct 2008 11:28] Jon Stephens

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.