diff options
| author | Georgi Kodinov <joro@sun.com> | 2009-05-27 16:05:29 +0300 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2009-05-27 16:05:29 +0300 |
| commit | bbe29a00d3ca24d4aa9c8c3b7c3f7bd8bcbd3389 (patch) | |
| tree | 84a2cbd1035921bbaa22dbb65522b2d16b307602 /mysql-test/t/sp-error.test | |
| parent | cb07978da9a24244cf71d9be86eeb794088f67c7 (diff) | |
| download | mariadb-git-bbe29a00d3ca24d4aa9c8c3b7c3f7bd8bcbd3389.tar.gz | |
Bug #38159: Function parsing problem generates misleading error message
Added a more detailed error message on calling an ambiguous missing function.
Diffstat (limited to 'mysql-test/t/sp-error.test')
| -rw-r--r-- | mysql-test/t/sp-error.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/sp-error.test b/mysql-test/t/sp-error.test index c839b1e4374..8143fd56c6d 100644 --- a/mysql-test/t/sp-error.test +++ b/mysql-test/t/sp-error.test @@ -2190,3 +2190,16 @@ delimiter ;| #drop procedure if exists bugNNNN| #--enable_warnings #create procedure bugNNNN... + +# +# 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; |