diff options
author | unknown <andrey@lmy004.> | 2006-01-26 21:26:19 +0100 |
---|---|---|
committer | unknown <andrey@lmy004.> | 2006-01-26 21:26:19 +0100 |
commit | c0161265cc718acfd42c3723990c69ef726cca14 (patch) | |
tree | 8ce5d707637ff312dec67d24b551198a6664a2eb /mysql-test/t/events.test | |
parent | 5c974cf18467af6aec600c74deb7625369b1c916 (diff) | |
parent | 3881218dc9e7449138e8a02a20453fc7fa482b12 (diff) | |
download | mariadb-git-c0161265cc718acfd42c3723990c69ef726cca14.tar.gz |
Merge ahristov@bk-internal.mysql.com:/home/bk/mysql-5.1-new
into lmy004.:/work/mysql-5.1-bug16419
mysql-test/r/events.result:
Auto merged
mysql-test/t/events.test:
Auto merged
sql/sql_yacc.yy:
Auto merged
Diffstat (limited to 'mysql-test/t/events.test')
-rw-r--r-- | mysql-test/t/events.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/events.test b/mysql-test/t/events.test index 5aa08f582cb..8c0fb371ca7 100644 --- a/mysql-test/t/events.test +++ b/mysql-test/t/events.test @@ -33,6 +33,15 @@ select count(*) from t_event3; drop event event3; drop table t_event3; + +create event e_26 on schedule at '2017-01-01 00:00:00' disabled 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 1503 +create event e_26 on schedule at NULL disabled do set @a = 5; +--error 1503 +create event e_26 on schedule at 'definitely not a datetime' disabled do set @a = 5; + set names utf8; create event задачка on schedule every 123 minute starts now() ends now() + interval 1 month do select 1; drop event задачка; |