Bug #16432 Events: error re interval misrepresents the facts
Submitted: 12 Jan 2006 4:31 Modified: 26 Jan 2006 2:27
Reporter: Peter Gulutzan Email Updates:
Status: Closed 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 4:31] Peter Gulutzan 
Description:
The error message for a too-big number is
"INTERVAL must be positive".  That's not
so, the interval is positive.

How to repeat:
mysql> create event e_45 on schedule every 12345678901234567890 second do set @ = 5;
ERROR 1516 (HY000): INTERVAL must be positive
[18 Jan 2006 19:43] 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/1292
[23 Jan 2006 16:52] Andrey Hristov 
Fixed in 5.1.6, though the bug was in a unreleased version so probably no need to appear in the Changelog
[26 Jan 2006 2:27] Mike Hillyer 
Documented in 5.1.6 changelog:

  <listitem>
        <para>
          Specifying a excessively large interval in a <literal>CREATE
            EVENT</literal> statement resulted in an inaccurate
          <literal>INTERVAL must be positive</literal> error message.
          (Bug #16432)
        </para>
      </listitem>