MySQL Bugs: #39163: Interval Field is returned without INTERVAL

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

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.

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)

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.