commit: 222cedbc7ba9102c5e2b480ed3ef6d890d8a9f50
Author: Brian Evans <grknight <AT> gentoo <DOT> org>
AuthorDate: Thu Nov 5 20:50:57 2015 +0000
Commit: Brian Evans <grknight <AT> gentoo <DOT> org>
CommitDate: Thu Nov 5 20:50:57 2015 +0000
URL: https://gitweb.gentoo.org/proj/mysql-extras.git/commit/?id=222cedbc
Add events_1 test patch wrt bug 564968
Signed-off-by: Brian Evans <grknight <AT> gentoo.org>
00000_index.txt | 8 ++++++++
20020_all_mysql-5.6-events_1-bug-78899.patch | 24 ++++++++++++++++++++++++
2 files changed, 32 insertions(+)
diff --git a/00000_index.txt b/00000_index.txt
index 49ec593..436dc69 100644
--- a/00000_index.txt
+++ b/00000_index.txt
@@ -1965,3 +1965,11 @@
@pn mysql
@@ Fix deprecated perl array defined syntax on mtr test script
@@ Ported forward from mysql 5.6; Oracle bug 18145121
+
+@patch 20020_all_mysql-5.6-events_1-bug-78899.patch
+@ver 5.06.00.00 to 5.06.27.99
+@pn mysql
+@pn percona-server
+@@ Fix events_1 test for October 2015
+@@ Patch backported from mariadb
+@@ Bug 564968 Upstream bug 78899
diff --git a/20020_all_mysql-5.6-events_1-bug-78899.patch
b/20020_all_mysql-5.6-events_1-bug-78899.patch
new file mode 100644
index 0000000..5fe4e3e
--- /dev/null
+++ b/20020_all_mysql-5.6-events_1-bug-78899.patch
@@ -0,0 +1,24 @@
+diff -rupN old/mysql/mysql-test/r/events_1.result
new/mysql/mysql-test/r/events_1.result
+--- old/mysql/mysql-test/r/events_1.result 2015-09-14 17:49:16.000000000
+0200
++++ new/mysql/mysql-test/r/events_1.result 2015-10-29 20:53:40.748451431
+0100
+@@ -114,7 +114,7 @@ create table t_event3 (a int, b float);
+ drop event if exists event3;
+ Warnings:
+ Note 1305 Event event3 does not exist
+-create event event3 on schedule every 50 + 10 minute starts
date_add("20100101", interval 5 minute) ends date_add("20151010", interval 5
day) comment "portokala_comment" DO insert into t_event3 values
(unix_timestamp(), rand());
++create event event3 on schedule every 50 + 10 minute starts
date_add("20100101", interval 5 minute) ends date_add("20251010", interval 5
day) comment "portokala_comment" DO insert into t_event3 values
(unix_timestamp(), rand());
+ select count(*) from t_event3;
+ count(*)
+ 0
+diff -rupN old/mysql/mysql-test/t/events_1.test
new/mysql/mysql-test/t/events_1.test
+--- old/mysql/mysql-test/t/events_1.test 2015-09-14 17:49:16.000000000
+0200
++++ new/mysql/mysql-test/t/events_1.test 2015-10-29 20:54:38.959698756
+0100
+@@ -125,7 +125,7 @@ drop event existant;
+
+ create table t_event3 (a int, b float);
+ drop event if exists event3;
+-create event event3 on schedule every 50 + 10 minute starts
date_add("20100101", interval 5 minute) ends date_add("20151010", interval 5
day) comment "portokala_comment" DO insert into t_event3 values
(unix_timestamp(), rand());
++create event event3 on schedule every 50 + 10 minute starts
date_add("20100101", interval 5 minute) ends date_add("20251010", interval 5
day) comment "portokala_comment" DO insert into t_event3 values
(unix_timestamp(), rand());
+ let $wait_condition=SELECT count(*)=0 from t_event3;
+ --source include/wait_condition.inc
+ select count(*) from t_event3;
