diff options
| author | Horst Hunger <horst.hunger@oracle.com> | 2017-01-03 09:06:19 +0100 |
|---|---|---|
| committer | Horst Hunger <horst.hunger@oracle.com> | 2017-01-03 09:06:19 +0100 |
| commit | e7a3ccf6b1b1b41e0fa191d26e9e775517c6deee (patch) | |
| tree | 180d8d5e6283eb43bd7a8767ec96ee4c4798e50f | |
| parent | e00810b934fd495009c1b8d47446714bdbc0b249 (diff) | |
| download | mariadb-git-e7a3ccf6b1b1b41e0fa191d26e9e775517c6deee.tar.gz | |
Bug#25335897: Modified the year of the date value from 2017 to 2037 in first event.
| -rw-r--r-- | mysql-test/r/events_2.result | 4 | ||||
| -rw-r--r-- | mysql-test/t/events_2.test | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/events_2.result b/mysql-test/r/events_2.result index 66ec00d7357..31a501d48a6 100644 --- a/mysql-test/r/events_2.result +++ b/mysql-test/r/events_2.result @@ -1,10 +1,10 @@ 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; +create event e_26 on schedule at '2037-01-01 00:00:00' disable do set @a = 5; 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 -events_test e_26 set @a = 5 root@localhost 2017-01-01 00:00:00 DROP +events_test e_26 set @a = 5 root@localhost 2037-01-01 00:00:00 DROP drop event e_26; create event e_26 on schedule at NULL disable do set @a = 5; ERROR HY000: Incorrect AT value: 'NULL' diff --git a/mysql-test/t/events_2.test b/mysql-test/t/events_2.test index 3d609654b21..d90ec100e42 100644 --- a/mysql-test/t/events_2.test +++ b/mysql-test/t/events_2.test @@ -13,7 +13,7 @@ use events_test; # mysql.event intact checking end # -create event e_26 on schedule at '2017-01-01 00:00:00' disable do set @a = 5; +create event e_26 on schedule at '2037-01-01 00:00:00' disable do set @a = 5; select db, name, body, definer, convert_tz(execute_at, 'UTC', 'SYSTEM'), on_completion from mysql.event; drop event e_26; --error ER_WRONG_VALUE |