Description of problem:
Test main.events_2 fails:
main.events_2 [ fail ]
Test ended at 2017-01-12 15:44:48
mysqltest: At line 18: query 'drop event e_26' failed: 1539: Unknown event 'e_26'
The result from queries just before the failure was:
drop database if exists events_test;
create database events_test;
create event e_26 on schedule at '2017-01-01 00:00:00' disable do set @a = 5;
Note 1588 Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
select db, name, body, definer, convert_tz(execute_at, 'UTC', 'SYSTEM'), on_completion from mysql.event;
db name body definer convert_tz(execute_at, 'UTC', 'SYSTEM') on_completion
- saving '/home/testhhorak/rpmbuild/BUILD/mysql-5.1.73/mysql-test/var/log/main.events_2/' to '/home/testhhorak/rpmbuild/BUILD/mysql-5.1.73/mysql-test/var/log/main.events_2/'
Only 7 of 13 completed.
mysql-test-run: *** ERROR: Not all tests completed
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. cd mysql-test
2. ./mysql-test-run --do-test=event
test does not fail
Easy to fix, even is created with date 2017-01-01, which already passed, so the event does not exist when it is expected. Changing the date to 2027 fixes the test failure.
Created attachment 1240135 [details]
proposed patch to fix event_2.text