summaryrefslogtreecommitdiff
path: root/mysql-test/r/sp-error.result
diff options
context:
space:
mode:
authorkroki/tomash@moonlight.intranet <>2006-07-24 15:10:50 +0400
committerkroki/tomash@moonlight.intranet <>2006-07-24 15:10:50 +0400
commit89ea3b01b5778c8abb9df6ae87e92d48a639bbcf (patch)
tree4a88e7b56ca2b89f3c93d5194fa97d869060e5de /mysql-test/r/sp-error.result
parentafb31714c513e40834cdf991420a6867047abb01 (diff)
downloadmariadb-git-89ea3b01b5778c8abb9df6ae87e92d48a639bbcf.tar.gz
BUG#14702: misleading error message when syntax error in
CREATE PROCEDURE The bug was fixed already. This changeset adds a test case.
Diffstat (limited to 'mysql-test/r/sp-error.result')
-rw-r--r--mysql-test/r/sp-error.result13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/sp-error.result b/mysql-test/r/sp-error.result
index 924963017eb..da1fc58db57 100644
--- a/mysql-test/r/sp-error.result
+++ b/mysql-test/r/sp-error.result
@@ -1174,3 +1174,16 @@ drop procedure bug15091;
drop function if exists bug16896;
create aggregate function bug16896() returns int return 1;
ERROR 42000: AGGREGATE is not supported for stored functions
+DROP PROCEDURE IF EXISTS bug14702;
+CREATE IF NOT EXISTS PROCEDURE bug14702()
+BEGIN
+END;
+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 'IF NOT EXISTS PROCEDURE bug14702()
+BEGIN
+END' at line 1
+CREATE PROCEDURE IF NOT EXISTS bug14702()
+BEGIN
+END;
+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 'IF NOT EXISTS bug14702()
+BEGIN
+END' at line 1