diff options
| author | unknown <pem@mysql.com> | 2006-01-31 17:00:50 +0100 |
|---|---|---|
| committer | unknown <pem@mysql.com> | 2006-01-31 17:00:50 +0100 |
| commit | 34d2c40ae7e287177f1fe7243c5e4bf8ff6b5623 (patch) | |
| tree | 4813661962e6202c4270aedf675d90e7977d8604 /mysql-test/r/sp-error.result | |
| parent | f358982ba3bb758a5fa0025ba2cc1464e5d40cde (diff) | |
| download | mariadb-git-34d2c40ae7e287177f1fe7243c5e4bf8ff6b5623.tar.gz | |
Added test case for BUG#15091: Sp Returns Unknown error in order clause....and there is
no order by clause
which was fixed by earlier changesets.
The error message is now the more generic "Unknown table ... in field list".
mysql-test/r/sp-error.result:
Updated results for new test case (BUG#15091).
mysql-test/t/sp-error.test:
New test case for BUG#15091.
Diffstat (limited to 'mysql-test/r/sp-error.result')
| -rw-r--r-- | mysql-test/r/sp-error.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/sp-error.result b/mysql-test/r/sp-error.result index fb544ccd8de..2766dca5845 100644 --- a/mysql-test/r/sp-error.result +++ b/mysql-test/r/sp-error.result @@ -1163,3 +1163,16 @@ return 1; end| ERROR 0A000: Not allowed to return a result set from a function drop table t1; +drop procedure if exists bug15091; +create procedure bug15091() +begin +declare selectstr varchar(6000) default ' '; +declare conditionstr varchar(5000) default ''; +set selectstr = concat(selectstr, +' and ', +c.operatorid, +'in (',conditionstr, ')'); +end| +call bug15091(); +ERROR 42S02: Unknown table 'c' in field list +drop procedure bug15091; |