Bug #17027 Events: invalid interval keywords
Submitted: 1 Feb 2006 22:45 Modified: 14 Feb 2006 11:13
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 (SUSE 10.0)
Assigned to: Andrey Hristov CPU Architecture:Any

[1 Feb 2006 22:45] Peter Gulutzan 
Description:
When I use "CREATE EVENT ... ON SCHEDULE EVERY ...",
MySQL allows these non-standard keywords:
QUARTER, YEAR_MONTH, DAY_HOUR, DAY_MINUTE,
DAY_SECOND, HOUR_SECOND, MINUTE_SECOND,
DAY_MICROSECOND, HOUR_MICROSECOND,
MINUTE_MICROSECOND, SECOND_MICROSECOND.

These keywords do not correspond to the keywords
for a standard interval expression.

Also, there is no check for invalid expressions like
'1' HOUR_MINUTE
but there's no need to fix that.

See also bug#16411.

How to repeat:
mysql> create event ee on schedule every '1' hour_minute do set @a=5;
Query OK, 1 row affected (0.00 sec)
[14 Feb 2006 11:13] Sergei Golubchik 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

see http://dev.mysql.com/doc/refman/5.1/en/events-create.html