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: | |
Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
Version: | 5.1+ | OS: | Any |
Assigned to: | Jon Stephens | CPU Architecture: | Any |
Tags: | qc |
[1 Sep 2008 16:20]
Jakub Vrana
[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.