diff options
author | unknown <mikael/pappa@dator5.(none)> | 2006-09-28 06:10:28 -0400 |
---|---|---|
committer | unknown <mikael/pappa@dator5.(none)> | 2006-09-28 06:10:28 -0400 |
commit | f6230caa32cd3e9e5bb52f5da7fa4b0657aff01d (patch) | |
tree | 687aeac5d2442fe1d000bd375095e834f5c778c2 /mysql-test/r/events_bugs.result | |
parent | 51b1ec1f44924d8ac6385d306ee9090575fe2386 (diff) | |
parent | 2d48a1f2a3c3539a977839b94a9d3fe703666753 (diff) | |
download | mariadb-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.result | 13 |
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; |