MySQL Bugs: #98860: main.events_bugs and main.events_1 fail because 2020-01-01 is considered future

Bug #98860	main.events_bugs and main.events_1 fail because 2020-01-01 is considered future
Submitted:	6 Mar 2020 14:07	Modified:	6 Mar 2020 19:58
Reporter:	Yura Sorokin (OCA)	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Tests: Server	Severity:	S7 (Test Cases)
Version:	5.6.47, 5.7.29, 8.0.19	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Both main.events_bugs and main.events_1 fail with the following errors
mysqltest: At line 69: Query 'ALTER EVENT event_starts_test ON SCHEDULE AT '2020-02-02 20:00:02'' failed.
ERROR 1589 (HY000): Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was not changed. Specify a time in the future.

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'

How to repeat:
./mtr --debug-server main.events_bugs
./mtr --debug-server main.events_1

Suggested fix:
Change '2020-XX-YY' date to '2038-XX-YY'

Not repeatable with more recent source built:
miguel@tikalmysql-test$./mtr --debug-server main.events_bugs
Logging: ./mtr  --debug-server main.events_bugs
2020-03-06 13:04:54 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2020-03-06 13:04:54 0 [Note] /home/miguel/dbsd/5.6/bin/mysqld (mysqld 5.6.48-debug) starting as process 7894 ...
2020-03-06 13:04:54 7894 [Note] Plugin 'FEDERATED' is disabled.
2020-03-06 13:04:54 7894 [Note] Binlog end
2020-03-06 13:04:54 7894 [Note] Shutting down plugin 'CSV'
2020-03-06 13:04:54 7894 [Note] Shutting down plugin 'MyISAM'
MySQL Version 5.6.48
Checking supported features...
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
Removing old var directory...
Creating var directory '/home/miguel/dbsd/5.6/mysql-test/var'...
Installing system database...
Using parallel: 1

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.events_bugs                         [ pass ]  10655
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 10.655 of 28 seconds executing testcases

Completed: All 1 tests were successful.

miguel@tikalmysql-test$./mtr --debug-server main.events_1
Logging: ./mtr  --debug-server main.events_1
2020-03-06 13:05:31 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2020-03-06 13:05:31 0 [Note] /home/miguel/dbsd/5.6/bin/mysqld (mysqld 5.6.48-debug) starting as process 7984 ...
2020-03-06 13:05:31 7984 [Note] Plugin 'FEDERATED' is disabled.
2020-03-06 13:05:31 7984 [Note] Binlog end
2020-03-06 13:05:31 7984 [Note] Shutting down plugin 'CSV'
2020-03-06 13:05:31 7984 [Note] Shutting down plugin 'MyISAM'
MySQL Version 5.6.48
Checking supported features...
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/miguel/dbsd/5.6/mysql-test/var'...
Installing system database...
Using parallel: 1

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.events_1                            [ pass ]   1890
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 1.890 of 15 seconds executing testcases

Completed: All 1 tests were successful.

miguel@tikalmysql-test$./mtr --debug-server main.events_bugs
Logging: ./mtr  --debug-server main.events_bugs
MySQL Version 5.7.30
Checking supported features...
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/miguel/dbsd/5.7/mysql-test/var'...
Installing system database...
Using parallel: 1

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
[100%] main.events_bugs                         [ pass ]  10801
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 10.801 of 48 seconds executing testcases

Completed: All 1 tests were successful.

miguel@tikalmysql-test$./mtr --debug-server main.events_1
Logging: ./mtr  --debug-server main.events_1
MySQL Version 5.7.30
Checking supported features...
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/miguel/dbsd/5.7/mysql-test/var'...
Installing system database...
Using parallel: 1

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
[100%] main.events_1                            [ pass ]   3635
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 3.635 of 37 seconds executing testcases

Completed: All 1 tests were successful.

miguel@tikalmysql-test$./mtr --debug-server main.events_bugs
Logging: ./mtr  --debug-server main.events_bugs
MySQL Version 8.0.20
Checking supported features
 - Binaries are debug compiled
Using 'all' suites
Collecting tests
Checking leftover processes
Removing old var directory
Creating var directory '/home/miguel/dbsd/8.0/mysql-test/var'
Installing system database
Using parallel: 1

==============================================================================
                  TEST NAME                       RESULT  TIME (ms) COMMENT
------------------------------------------------------------------------------
[100%] main.events_bugs                          [ pass ]  74504
------------------------------------------------------------------------------
The servers were restarted 0 times
The servers were reinitialized 0 times
Spent 74.504 of 204 seconds executing testcases

Completed: All 1 tests were successful.

miguel@tikalmysql-test$./mtr --debug-server main.events_1
Logging: ./mtr  --debug-server main.events_1
MySQL Version 8.0.20
Checking supported features
 - Binaries are debug compiled
Using 'all' suites
Collecting tests
Checking leftover processes
Removing old var directory
Creating var directory '/home/miguel/dbsd/8.0/mysql-test/var'
Installing system database
Using parallel: 1

==============================================================================
                  TEST NAME                       RESULT  TIME (ms) COMMENT
------------------------------------------------------------------------------
[100%] main.events_1                             [ pass ]  39935
------------------------------------------------------------------------------
The servers were restarted 0 times
The servers were reinitialized 0 times
Spent 39.935 of 243 seconds executing testcases

Completed: All 1 tests were successful.

Is this same as Bug#98107 ?

https://bugs.mysql.com/bug.php?id=98107

Thank you for the feedback.