summaryrefslogtreecommitdiff
path: root/mysql-test/t/events.test
diff options
context:
space:
mode:
authorunknown <andrey@lmy004.>2006-01-26 21:26:19 +0100
committerunknown <andrey@lmy004.>2006-01-26 21:26:19 +0100
commitc0161265cc718acfd42c3723990c69ef726cca14 (patch)
tree8ce5d707637ff312dec67d24b551198a6664a2eb /mysql-test/t/events.test
parent5c974cf18467af6aec600c74deb7625369b1c916 (diff)
parent3881218dc9e7449138e8a02a20453fc7fa482b12 (diff)
downloadmariadb-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.test9
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 задачка;