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

[6 Mar 2020 14:07] Yura Sorokin
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'
[6 Mar 2020 16:19] MySQL Verification Team
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.
[6 Mar 2020 16:40] Tsubasa Tanaka
Is this same as Bug#98107 ?

https://bugs.mysql.com/bug.php?id=98107
[6 Mar 2020 19:58] MySQL Verification Team
Thank you for the feedback.