diff options
| author | unknown <sergefp@mysql.com> | 2005-01-19 23:11:50 +0300 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2005-01-19 23:11:50 +0300 |
| commit | 246df068dfa5582792a568585d6842ed0424ffac (patch) | |
| tree | c735a610ece570f5cdcc46d9ead5b689894aef1c /mysql-test/r/subselect.result | |
| parent | 0c20ad6c1529a9efe9dcc84cc84039bb36471216 (diff) | |
| parent | c8343423c2e152536f3b8b5265d0f3746625894e (diff) | |
| download | mariadb-git-246df068dfa5582792a568585d6842ed0424ffac.tar.gz | |
Merge mysql.com:/dbdata/psergey/mysql-4.1-bug7885
into mysql.com:/dbdata/psergey/mysql-5.0-bug7885
mysql-test/r/subselect.result:
Auto merged
mysql-test/t/subselect.test:
Auto merged
sql/item_subselect.cc:
Auto merged
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 1a1a9a256db..5fd2053a3ec 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -2160,3 +2160,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; |