summaryrefslogtreecommitdiff
path: root/mysql-test/t/sp-error.test
diff options
context:
space:
mode:
authorGeorgi Kodinov <joro@sun.com>2009-05-27 18:19:44 +0300
committerGeorgi Kodinov <joro@sun.com>2009-05-27 18:19:44 +0300
commitc675beab98d90e2f1a606c17d106740d1394071a (patch)
treeef20b1214af011ce8ef6a3fb904fb115e723cb71 /mysql-test/t/sp-error.test
parentc8a7b7914203a95c30ce45e800f7676744248bf7 (diff)
parent80730df7d634e1a620c864d6665d6e66ccad447a (diff)
downloadmariadb-git-c675beab98d90e2f1a606c17d106740d1394071a.tar.gz
merged 5.0-bugteam to 5.1-bugteam
Diffstat (limited to 'mysql-test/t/sp-error.test')
-rw-r--r--mysql-test/t/sp-error.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/sp-error.test b/mysql-test/t/sp-error.test
index 8d7c6d75a34..66b960c938f 100644
--- a/mysql-test/t/sp-error.test
+++ b/mysql-test/t/sp-error.test
@@ -2435,3 +2435,16 @@ delimiter ;$$
#
LOAD DATA INFILE '../../tmp/proc.txt' INTO TABLE mysql.proc;
remove_file $MYSQLTEST_VARDIR/tmp/proc.txt;
+
+#
+# Bug #38159: Function parsing problem generates misleading error message
+#
+
+CREATE TABLE t1 (a INT, b INT);
+INSERT INTO t1 VALUES (1,1), (2,2);
+--error ER_FUNC_INEXISTENT_NAME_COLLISION
+SELECT MAX (a) FROM t1 WHERE b = 999999;
+SELECT AVG (a) FROM t1 WHERE b = 999999;
+--error ER_SP_DOES_NOT_EXIST
+SELECT non_existent (a) FROM t1 WHERE b = 999999;
+DROP TABLE t1;