Bug #16411 Events: Microsecond intervals are allowed
Submitted: 12 Jan 2006 4:59 Modified: 27 Feb 2006 21:20
Reporter: Peter Gulutzan
Status: Closed
Category:Server: SP Severity:S3 (Non-critical)
Version:5.1.6-alpha-debug OS:Linux (linux)
Assigned to: Andrey Hristov Target Version:

[12 Jan 2006 4:59] Peter Gulutzan 
Description:
I can say "CREATE EVENT ... EVERY 1 MICROSECOND". But
realistically the switch can't even occur 100 times per second.
So, this is deceptive. Don't allow syntax for what you can't do.

How to repeat:
mysql> create event e_17 on schedule every 1 microsecond do drop table t;
Query OK, 1 row affected (0.00 sec)
[20 Feb 2006 16:08] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2917
[24 Feb 2006 14:05] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/3105
[24 Feb 2006 14:11] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/3106
[24 Feb 2006 14:12] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/3107
[24 Feb 2006 15:31] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/3111
[25 Feb 2006 0:08] Andrey Hristov 
Fixed in 5.1.8. MICROSECOND is disallowed when creating/altering an event. If mysql.event
is directly tempered the scheduler will skip the event and refuse to start till the
conflicting row is deleted. show create event will give an error in such case. select *
from information_schema also.
[27 Feb 2006 21:20] Mike Hillyer 
Documented in 5.1.8 changelog:

      <listitem>
        <para>
          <literal>MICROSECOND</literal> intervals are no longer allowed
          for events. (Bug #16411)
        </para>
      </listitem>