Bug #16403 Events: In CREATE EVENT, I can't omit the schedule
Submitted: 12 Jan 2006 3:46 Modified: 3 Jun 2006 14:00
Reporter: Peter Gulutzan Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S3 (Non-critical)
Version:5.1.6-alpha-debug OS:Linux (linux)
Assigned to: Andrey Hristov CPU Architecture:Any

[12 Jan 2006 3:46] Peter Gulutzan 
Description:
Now "CREATE EVENT ... ON SCHEDULE ..." is compulsory.
It should default to AT NOW(), which would cause the
event to happen immediately, but with a thread change.

How to repeat:
mysql> create event if not exists e_12 do drop table t;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'do drop table t' at line 1
[2 Jun 2006 22:40] Brian Aker 
I think the behavior Peter is suggestion is good behavior for the feature, but what I do not agree is that is it required for the first version. What I can not find at the moment is from worklog what the original behavior was defined to be in the first version.
[3 Jun 2006 14:00] Peter Gulutzan 
There's no support for calling this a bug. The worklog does not say that the SCHEDULE option can be omitted.