diff options
| author | unknown <timour@askmonty.org> | 2012-06-19 15:06:45 +0300 |
|---|---|---|
| committer | unknown <timour@askmonty.org> | 2012-06-19 15:06:45 +0300 |
| commit | 0b93b444b6c4de6b219fd3a4b3d5fa2e388dc211 (patch) | |
| tree | 14476572c91530f3b354041e1683e2b042b9a9cd /mysql-test/t/subselect4.test | |
| parent | 37f8094652c438360b66aa04a46acb96d3eea6b7 (diff) | |
| parent | cf3a499f541e66e1b8aa96fe16e36a48ed1c0a0e (diff) | |
| download | mariadb-git-0b93b444b6c4de6b219fd3a4b3d5fa2e388dc211.tar.gz | |
Merged the fix for bug lp:944706, mdev-193
Diffstat (limited to 'mysql-test/t/subselect4.test')
| -rw-r--r-- | mysql-test/t/subselect4.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/subselect4.test b/mysql-test/t/subselect4.test index 832d6d85c21..b53967e35e5 100644 --- a/mysql-test/t/subselect4.test +++ b/mysql-test/t/subselect4.test @@ -977,6 +977,14 @@ SELECT * FROM t1 WHERE FROM t3 AS SQ1_t1 JOIN t3 AS SQ1_t3 ON SQ1_t3.f4 GROUP BY SQ1_t1.f4)); +--error ER_SUBQUERY_NO_1_ROW +SELECT * FROM t1 WHERE +(SELECT f2 FROM t2 + WHERE f4 <= ALL + (SELECT max(SQ1_t1.f4) + FROM t3 AS SQ1_t1 JOIN t3 AS SQ1_t3 ON SQ1_t3.f4 + GROUP BY SQ1_t1.f4)); + drop table t1, t2, t3; --echo # |