Bug 1412805

Summary: failing test main.events_2
Product: Red Hat Enterprise Linux 6 Reporter: Honza Horak <hhorak>
Component: mysqlAssignee: Michal Schorm <mschorm>
Status: CLOSED WONTFIX QA Contact: qe-baseos-daemons
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.9CC: databases-maint, mmuzila, riehecky
Target Milestone: rcKeywords: Patch
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-04-07 19:20:18 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
proposed patch to fix event_2.text none

Description Honza Horak 2017-01-12 20:52:10 UTC 
Description of problem:

Test main.events_2 fails:
main.events_2                            [ fail ]
        Test ended at 2017-01-12 15:44:48

CURRENT_TEST: main.events_2
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;
use events_test;
create event e_26 on schedule at '2017-01-01 00:00:00' disable do set @a = 5;
Warnings:
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):
mysql-5.1.73-8.el6_8

How reproducible:
every-time

Steps to Reproduce:
1. cd mysql-test
2. ./mysql-test-run --do-test=event

Actual results:
test fails

Expected results:
test does not fail

Additional info:
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.
Comment 1 Honza Horak 2017-01-12 21:50:12 UTC 
Created attachment 1240135 [details]
proposed patch to fix event_2.text