summaryrefslogtreecommitdiff
path: root/mysql-test/t/sp-error.test
diff options
context:
space:
mode:
authorunknown <kroki/tomash@moonlight.intranet>2006-07-24 15:10:50 +0400
committerunknown <kroki/tomash@moonlight.intranet>2006-07-24 15:10:50 +0400
commit3037459ad50cd06c6b8c04b942f505d0f00a9634 (patch)
tree4a88e7b56ca2b89f3c93d5194fa97d869060e5de /mysql-test/t/sp-error.test
parent12d6b9c7f131cd623e384b8f176806d5e5dac7e2 (diff)
downloadmariadb-git-3037459ad50cd06c6b8c04b942f505d0f00a9634.tar.gz
BUG#14702: misleading error message when syntax error in
CREATE PROCEDURE The bug was fixed already. This changeset adds a test case. mysql-test/r/sp-error.result: Add result for bug#14702: misleading error message when syntax error in CREATE PROCEDURE. mysql-test/t/sp-error.test: Add test case for bug#14702: misleading error message when syntax error in CREATE PROCEDURE.
Diffstat (limited to 'mysql-test/t/sp-error.test')
-rw-r--r--mysql-test/t/sp-error.test22
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/t/sp-error.test b/mysql-test/t/sp-error.test
index a4ab5d98922..2abb923efbb 100644
--- a/mysql-test/t/sp-error.test
+++ b/mysql-test/t/sp-error.test
@@ -1707,6 +1707,28 @@ create aggregate function bug16896() returns int return 1;
#
+# BUG#14702: misleading error message when syntax error in CREATE
+# PROCEDURE
+#
+# Misleading error message was given when IF NOT EXISTS was used in
+# CREATE PROCEDURE.
+#
+--disable_warnings
+DROP PROCEDURE IF EXISTS bug14702;
+--enable_warnings
+
+--error ER_PARSE_ERROR
+CREATE IF NOT EXISTS PROCEDURE bug14702()
+BEGIN
+END;
+
+--error ER_PARSE_ERROR
+CREATE PROCEDURE IF NOT EXISTS bug14702()
+BEGIN
+END;
+
+
+#
# BUG#NNNN: New bug synopsis
#
#--disable_warnings