summaryrefslogtreecommitdiff
path: root/mysql-test/r/events_bugs.result
diff options
context:
space:
mode:
authorunknown <mikael/pappa@dator5.(none)>2006-09-28 06:10:28 -0400
committerunknown <mikael/pappa@dator5.(none)>2006-09-28 06:10:28 -0400
commitf6230caa32cd3e9e5bb52f5da7fa4b0657aff01d (patch)
tree687aeac5d2442fe1d000bd375095e834f5c778c2 /mysql-test/r/events_bugs.result
parent51b1ec1f44924d8ac6385d306ee9090575fe2386 (diff)
parent2d48a1f2a3c3539a977839b94a9d3fe703666753 (diff)
downloadmariadb-git-f6230caa32cd3e9e5bb52f5da7fa4b0657aff01d.tar.gz
Merge dator5.(none):/home/pappa/clean-mysql-5.1
into dator5.(none):/home/pappa/bug18198 sql/sql_table.cc: Auto merged
Diffstat (limited to 'mysql-test/r/events_bugs.result')
-rw-r--r--mysql-test/r/events_bugs.result13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/events_bugs.result b/mysql-test/r/events_bugs.result
index 458fd151130..08be6924e03 100644
--- a/mysql-test/r/events_bugs.result
+++ b/mysql-test/r/events_bugs.result
@@ -213,4 +213,17 @@ create event e_53 on schedule every 5 second starts (select s1 from ttx) do drop
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select s1 from ttx) do drop table t' at line 1
create event e_53 on schedule every 5 second ends (select s1 from ttx) do drop table t;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select s1 from ttx) do drop table t' at line 1
+drop event if exists e_16;
+drop procedure if exists p_16;
+create event e_16 on schedule every 1 second do set @a=5;
+create procedure p_16 () alter event e_16 on schedule every @a second;
+set @a = null;
+call p_16();
+ERROR HY000: Incorrect INTERVAL value: 'NULL'
+call p_16();
+ERROR HY000: Incorrect INTERVAL value: 'NULL'
+set @a= 6;
+call p_16();
+drop procedure p_16;
+drop event e_16;
drop database events_test;