diff options
Diffstat (limited to 'mysql-test/main/events_bugs.result')
| -rw-r--r-- | mysql-test/main/events_bugs.result | 28 |
1 files changed, 25 insertions, 3 deletions
diff --git a/mysql-test/main/events_bugs.result b/mysql-test/main/events_bugs.result index 0615dac53b1..13793503b80 100644 --- a/mysql-test/main/events_bugs.result +++ b/mysql-test/main/events_bugs.result @@ -35,12 +35,34 @@ SET NAMES latin1; set @a=3; CREATE PROCEDURE p_16 () CREATE EVENT e_16 ON SCHEDULE EVERY @a SECOND DO SET @a=5; ERROR HY000: Recursion of EVENT DDL statements is forbidden when body is present +SET time_zone='+00:00'; +SET timestamp=UNIX_TIMESTAMP('2023-02-13 00:00:00'); create event e_55 on schedule at 99990101000000 do drop table t; -ERROR HY000: Incorrect AT value: '99990101000000' +Warnings: +Warning 1292 Truncated incorrect timestamp value: '9999-01-01 00:00:00' +Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. +show create event e_55; +Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation +e_55 +00:00 CREATE DEFINER=`root`@`localhost` EVENT `e_55` ON SCHEDULE AT '2038-01-19 03:14:07' ON COMPLETION NOT PRESERVE ENABLE DO drop table t latin1 latin1_swedish_ci latin1_swedish_ci +drop event e_55; create event e_55 on schedule every 10 hour starts 99990101000000 do drop table t; -ERROR HY000: Incorrect STARTS value: '99990101000000' +Warnings: +Warning 1292 Truncated incorrect timestamp value: '9999-01-01 00:00:00' +Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. +show create event e_55; +Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation +e_55 +00:00 CREATE DEFINER=`root`@`localhost` EVENT `e_55` ON SCHEDULE EVERY 10 HOUR STARTS '2038-01-19 03:14:07' ON COMPLETION NOT PRESERVE ENABLE DO drop table t latin1 latin1_swedish_ci latin1_swedish_ci +drop event e_55; create event e_55 on schedule every 10 minute ends 99990101000000 do drop table t; -ERROR HY000: ENDS is either invalid or before STARTS +Warnings: +Warning 1292 Truncated incorrect timestamp value: '9999-01-01 00:00:00' +Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. +show create event e_55; +Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation +e_55 +00:00 CREATE DEFINER=`root`@`localhost` EVENT `e_55` ON SCHEDULE EVERY 10 MINUTE STARTS '2023-02-13 00:00:00' ENDS '2038-01-19 03:14:07' ON COMPLETION NOT PRESERVE ENABLE DO drop table t latin1 latin1_swedish_ci latin1_swedish_ci +drop event e_55; +SET time_zone=DEFAULT; +SET timestamp=DEFAULT; create event e_55 on schedule at 10000101000000 do drop table t; ERROR HY000: Incorrect AT value: '10000101000000' create event e_55 on schedule at 20000101000000 do drop table t; |