Bug #94085 wrong metadata while create an event
Submitted: 28 Jan 2019 2:18 Modified: 21 Feb 2019 2:58
Reporter: JianJun Shi Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:8.0.13, 8.0.14 OS:Linux
Assigned to: CPU Architecture:Any
Tags: regression

[28 Jan 2019 2:18] JianJun Shi
Description:
While create an event as well as declare it to execute every 2 week, then check information on the information_schema.events table. 
Astonishment is the value of "INTERVAL_VALUE" turn to 14, it mains that this event execute every 14 week??? Which is seriously differ with my original intention.

How to repeat:
create database CREATE_EVENT_061;
show databases like 'CREATE_EVENT_061';
use CREATE_EVENT_061;
create table TABLE_TEST_01(time TIMESTAMP);
set @@global.event_scheduler=ON;
show variables like 'event_scheduler';
create definer='mysql.sys'@'localhost' event if not exists event_test_cc on schedule EVERY 2 WEEK disable on slave comment 'addcomment123456789012345678901234567890123456789012345678901234' do insert into table_test_01 values(now());
select EVENT_SCHEMA,EVENT_NAME,DEFINER,EVENT_DEFINITION,INTERVAL_VALUE,INTERVAL_FIELD,STATUS,ON_COMPLETION,EVENT_COMMENT from information_schema.events where EVENT_NAME='event_test_cc' and EVENT_SCHEMA='CREATE_EVENT_061';
[28 Jan 2019 6:04] Umesh Shastry
Hello JianJun,

Thank you for the report and test case.
Verified as described with 8.0.14 build.

regards,
Umesh
[21 Feb 2019 2:58] Paul Dubois
Posted by developer:
 
Fixed in 8.0.16.

Event creation could store an incorrect repetition interval.