Description:
test case main.events_bugs failed.
==============================================================================
TEST NAME RESULT TIME (ms) COMMENT
------------------------------------------------------------------------------
[100%] main.events_bugs [ fail ]
Test ended at 2020-02-12 11:35:40
CURRENT_TEST: main.events_bugs
mysqltest: At line 1036: Query 'CREATE EVENT e1 ON SCHEDULE AT '2020-01-01 00:00:00' DO SET @a = 1' succeeded, should have failed with error '1290'
==============================================================================
TEST NAME RESULT TIME (ms) COMMENT
------------------------------------------------------------------------------
[100%] main.events_bugs [ fail ]
Test ended at 2020-02-12 11:35:40
CURRENT_TEST: main.events_bugs
mysqltest: At line 1036: Query 'CREATE EVENT e1 ON SCHEDULE AT '2020-01-01 00:00:00' DO SET @a = 1' succeeded, should have failed with error '1290'
If change events_bugs.test file like below, it will pass.
==============================================================================
TEST NAME RESULT TIME (ms) COMMENT
------------------------------------------------------------------------------
[100%] main.events_bugs [ fail ]
Test ended at 2020-02-12 11:42:06
CURRENT_TEST: main.events_bugs
--- /home/duting/mysql-server-mysql-8.0.18/mysql-test/r/events_bugs.result 2019-09-20 11:29:23.000000000 +0300
+++ /home/duting/mysql-server-mysql-8.0.18/bld/mysql-test/var/log/events_bugs.reject 2020-02-12 06:42:06.593970270 +0300
@@ -647,7 +647,7 @@
# Connection: u1_con (mysqltest_u1@localhost/events_test).
#
-CREATE EVENT e1 ON SCHEDULE AT '2020-01-01 00:00:00' DO SET @a = 1;
+CREATE EVENT e1 ON SCHEDULE AT '2021-01-01 00:00:00' DO SET @a = 1;
ERROR HY000: The MySQL server is running with the --read-only option so it cannot execute this statement
ALTER EVENT e1 COMMENT 'comment';
@@ -660,7 +660,7 @@
# Connection: root_con (root@localhost/events_test).
#
-CREATE EVENT e1 ON SCHEDULE AT '2020-01-01 00:00:00' DO SET @a = 1;
+CREATE EVENT e1 ON SCHEDULE AT '2021-01-01 00:00:00' DO SET @a = 1;
How to repeat:
see description.
Suggested fix:
8.0.17 works success. So I do not know if some features in 8.0.18 make it failed. If so, fix this test case. Or there maybe some bug in 8.0.18.
Description: test case main.events_bugs failed. ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [100%] main.events_bugs [ fail ] Test ended at 2020-02-12 11:35:40 CURRENT_TEST: main.events_bugs mysqltest: At line 1036: Query 'CREATE EVENT e1 ON SCHEDULE AT '2020-01-01 00:00:00' DO SET @a = 1' succeeded, should have failed with error '1290' ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [100%] main.events_bugs [ fail ] Test ended at 2020-02-12 11:35:40 CURRENT_TEST: main.events_bugs mysqltest: At line 1036: Query 'CREATE EVENT e1 ON SCHEDULE AT '2020-01-01 00:00:00' DO SET @a = 1' succeeded, should have failed with error '1290' If change events_bugs.test file like below, it will pass. ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [100%] main.events_bugs [ fail ] Test ended at 2020-02-12 11:42:06 CURRENT_TEST: main.events_bugs --- /home/duting/mysql-server-mysql-8.0.18/mysql-test/r/events_bugs.result 2019-09-20 11:29:23.000000000 +0300 +++ /home/duting/mysql-server-mysql-8.0.18/bld/mysql-test/var/log/events_bugs.reject 2020-02-12 06:42:06.593970270 +0300 @@ -647,7 +647,7 @@ # Connection: u1_con (mysqltest_u1@localhost/events_test). # -CREATE EVENT e1 ON SCHEDULE AT '2020-01-01 00:00:00' DO SET @a = 1; +CREATE EVENT e1 ON SCHEDULE AT '2021-01-01 00:00:00' DO SET @a = 1; ERROR HY000: The MySQL server is running with the --read-only option so it cannot execute this statement ALTER EVENT e1 COMMENT 'comment'; @@ -660,7 +660,7 @@ # Connection: root_con (root@localhost/events_test). # -CREATE EVENT e1 ON SCHEDULE AT '2020-01-01 00:00:00' DO SET @a = 1; +CREATE EVENT e1 ON SCHEDULE AT '2021-01-01 00:00:00' DO SET @a = 1; How to repeat: see description. Suggested fix: 8.0.17 works success. So I do not know if some features in 8.0.18 make it failed. If so, fix this test case. Or there maybe some bug in 8.0.18.