diff options
-rw-r--r-- | mysql-test/r/events_1.result | 3 | ||||
-rw-r--r-- | mysql-test/t/events_1.test | 3 |
2 files changed, 4 insertions, 2 deletions
diff --git a/mysql-test/r/events_1.result b/mysql-test/r/events_1.result index 78115497fc6..637cd26b79a 100644 --- a/mysql-test/r/events_1.result +++ b/mysql-test/r/events_1.result @@ -115,7 +115,8 @@ 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 --git a/mysql-test/t/events_1.test b/mysql-test/t/events_1.test index 7cd488bc376..badcfe4624f 100644 --- a/mysql-test/t/events_1.test +++ b/mysql-test/t/events_1.test @@ -127,7 +127,8 @@ 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; |