diff options
| author | unknown <timour@askmonty.org> | 2011-05-02 21:59:16 +0300 |
|---|---|---|
| committer | unknown <timour@askmonty.org> | 2011-05-02 21:59:16 +0300 |
| commit | 5dc11616b266bfcd0849cbf44bf4222b7a661f46 (patch) | |
| tree | c64ae4a7f8f12332f7d3bd4817626fa00c1e4981 /mysql-test/t/subselect3.test | |
| parent | 8ac88c88f0038350064429fda626233260eb6721 (diff) | |
| parent | 0f4236659c2af3720d57255e224b3a8bb4f1d697 (diff) | |
| download | mariadb-git-5dc11616b266bfcd0849cbf44bf4222b7a661f46.tar.gz | |
MWL#89
Merge with 5.3
Diffstat (limited to 'mysql-test/t/subselect3.test')
| -rw-r--r-- | mysql-test/t/subselect3.test | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/t/subselect3.test b/mysql-test/t/subselect3.test index dc625239e84..0c1523a04ca 100644 --- a/mysql-test/t/subselect3.test +++ b/mysql-test/t/subselect3.test @@ -683,7 +683,8 @@ SELECT a, ROW(11, 12) = (SELECT a, 12), ROW(11, 12) IN (SELECT a, 12) FROM t1; # The x alias is used below to workaround bug #40674. # Regression tests for sum function on outer column in subselect from dual: SELECT a AS x, ROW(11, 12) = (SELECT MAX(x), 22), ROW(11, 12) IN (SELECT MAX(x), 22) FROM t1; ---echo # 2nd and 3rd columns should be same for x == 11 only +--echo # 2nd and 3rd columns should be same +EXPLAIN SELECT a AS x, ROW(11, 12) = (SELECT MAX(x), 12), ROW(11, 12) IN (SELECT MAX(x), 12) FROM t1; SELECT a AS x, ROW(11, 12) = (SELECT MAX(x), 12), ROW(11, 12) IN (SELECT MAX(x), 12) FROM t1; DROP TABLE t1; |