diff options
| author | unknown <timour@askmonty.org> | 2011-03-01 14:16:28 +0200 |
|---|---|---|
| committer | unknown <timour@askmonty.org> | 2011-03-01 14:16:28 +0200 |
| commit | 7895c35874c76a88d7b1be609f06fbe6f266aab7 (patch) | |
| tree | a1f57cf7c7bb129bb67d0aed5176d0bcaf4b7920 /mysql-test/suite/pbxt/t | |
| parent | 39616eb9ef974c69e73bcb80cd7e3c40228910fd (diff) | |
| parent | 759d71eba1842bbde7b44fc42e1098590b136320 (diff) | |
| download | mariadb-git-7895c35874c76a88d7b1be609f06fbe6f266aab7.tar.gz | |
MWL#89
Merge MWL#89 with 5.3.
Diffstat (limited to 'mysql-test/suite/pbxt/t')
| -rw-r--r-- | mysql-test/suite/pbxt/t/subselect.test | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/suite/pbxt/t/subselect.test b/mysql-test/suite/pbxt/t/subselect.test index 19658cb202e..3f4d6a9a870 100644 --- a/mysql-test/suite/pbxt/t/subselect.test +++ b/mysql-test/suite/pbxt/t/subselect.test @@ -2052,7 +2052,7 @@ SELECT b, MAX(c) FROM t2 GROUP BY b, (SELECT c FROM t2 WHERE b > 2); --error 1242 SELECT b, MAX(c) FROM t2 GROUP BY b, (SELECT c FROM t2 WHERE b > 1); - +--sorted_result SELECT a FROM t1 GROUP BY a HAVING IFNULL((SELECT b FROM t2 WHERE b > 2), (SELECT c FROM t2 WHERE c=a AND b > 2 ORDER BY b)) > 3; @@ -2060,7 +2060,7 @@ SELECT a FROM t1 GROUP BY a SELECT a FROM t1 GROUP BY a HAVING IFNULL((SELECT b FROM t2 WHERE b > 1), (SELECT c FROM t2 WHERE c=a AND b > 2 ORDER BY b)) > 3; - +--sorted_result SELECT a FROM t1 GROUP BY a HAVING IFNULL((SELECT b FROM t2 WHERE b > 4), (SELECT c FROM t2 WHERE c=a AND b > 2 ORDER BY b)) > 3; @@ -2068,7 +2068,7 @@ SELECT a FROM t1 GROUP BY a SELECT a FROM t1 GROUP BY a HAVING IFNULL((SELECT b FROM t2 WHERE b > 4), (SELECT c FROM t2 WHERE c=a AND b > 1 ORDER BY b)) > 3; - +--sorted_result SELECT a FROM t1 ORDER BY IFNULL((SELECT b FROM t2 WHERE b > 2), (SELECT c FROM t2 WHERE c=a AND b > 2 ORDER BY b)); @@ -2076,7 +2076,7 @@ SELECT a FROM t1 SELECT a FROM t1 ORDER BY IFNULL((SELECT b FROM t2 WHERE b > 1), (SELECT c FROM t2 WHERE c=a AND b > 1 ORDER BY b)); - +--sorted_result SELECT a FROM t1 ORDER BY IFNULL((SELECT b FROM t2 WHERE b > 4), (SELECT c FROM t2 WHERE c=a AND b > 2 ORDER BY b)); |