diff options
| author | unknown <sergefp@mysql.com> | 2005-01-18 17:26:05 +0300 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2005-01-18 17:26:05 +0300 |
| commit | 2e50981af908bff71c330d4caff40338ee2356d8 (patch) | |
| tree | 035c656b4835d8f2485a57293ee29f56193937a5 /mysql-test/r/subselect.result | |
| parent | e46d235a08a35bdd5536b4b2b99ed3a5b6910cdf (diff) | |
| download | mariadb-git-2e50981af908bff71c330d4caff40338ee2356d8.tar.gz | |
Fix for BUG#7885
mysql-test/r/subselect.result:
Testcase for BUG#7885
mysql-test/t/subselect.test:
Testcase for BUG#7885
sql/item_subselect.cc:
Fix for BUG#7885: In Item_subselect::fix_fields, return error if engine->prepare fails.
Also removed redundant code line.
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 9c442d8e3cb..02662f9900a 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -2152,3 +2152,11 @@ WHERE f1 <> ALL ( SELECT SUM(f1) AS sf1 FROM t2 HAVING sf1 > 10000); f1 NULL 1 +drop table t1,t2; +create table t1 (a1 int); +create table t2 (b1 int); +select * from t1 where a2 > any(select b1 from t2); +ERROR 42S22: Unknown column 'a2' in 'scalar IN/ALL/ANY subquery' +select * from t1 where a1 > any(select b1 from t2); +a1 +drop table t1,t2; |