MySQL Bugs: #94085: wrong metadata while create an event

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

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';

Hello JianJun,

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

regards,
Umesh

Posted by developer:
 
Fixed in 8.0.16.

Event creation could store an incorrect repetition interval.