Bug #39163 Interval Field is returned without INTERVAL_ prefix
Submitted: 1 Sep 2008 16:20 Modified: 15 Sep 2008 17:40
Reporter: Jakub Vrana (Candidate Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1+ OS:Any
Assigned to: Jon Stephens CPU Architecture:Any
Tags: qc
Triage: D3 (Medium)

[1 Sep 2008 16:20] Jakub Vrana
Description:
SHOW EVENTS and information_schema.EVENTS should return Interval Field with INTERVAL_ prefix according to documentation:

http://dev.mysql.com/doc/refman/5.1/en/events-table.html (description, example)
http://dev.mysql.com/doc/refman/5.1/en/show-events.html (example)

However the value is returned without any prefix.

How to repeat:
SELECT INTERVAL_FIELD FROM information_schema.EVENTS
-- returns DAY
-- should return INTERVAL_DAY

Suggested fix:
Remove INTERVAL_ prefix from documentation.
[1 Sep 2008 16:54] Valeriy Kravchuk
Thank you for a problem report. Verified just as described:

C:\Program Files\MySQL\MySQL Server 6.0\bin>mysql -uroot -proot -P3310 test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.26-rc-community-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT INTERVAL_FIELD FROM information_schema.EVENTS;
Empty set (0.00 sec)

mysql> create event e_daily
    -> ON SCHEDULE EVERY 1 DAY
    ->     STARTS CURRENT_TIMESTAMP + INTERVAL 6 HOUR
    ->     DISABLE
    ->     COMMENT 'Saves total number of sessions and
    '>              clears the table once per day.'
    ->     DO select 1;
Query OK, 0 rows affected (0.08 sec)

mysql> SELECT INTERVAL_FIELD FROM information_schema.EVENTS;
+----------------+
| INTERVAL_FIELD |
+----------------+
| DAY            |
+----------------+
1 row in set (0.01 sec)
[15 Sep 2008 17:40] 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.