diff options
| author | unknown <timour@askmonty.org> | 2011-01-11 14:04:08 +0200 |
|---|---|---|
| committer | unknown <timour@askmonty.org> | 2011-01-11 14:04:08 +0200 |
| commit | b0be3e2c6834d427c4e652a0203d166625871a35 (patch) | |
| tree | 555b0a562b8a99bd51b70ad1b7e6ae41faa34e3e /mysql-test/r/subselect3.result | |
| parent | cb4fa7f401267bf887066100726c53f10b712e6d (diff) | |
| parent | 2e42948ed3f6eeef5fb61a5d8907ba01dd66f4e3 (diff) | |
| download | mariadb-git-b0be3e2c6834d427c4e652a0203d166625871a35.tar.gz | |
Merge MWL#89 into 5.3 main.
Diffstat (limited to 'mysql-test/r/subselect3.result')
| -rw-r--r-- | mysql-test/r/subselect3.result | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/mysql-test/r/subselect3.result b/mysql-test/r/subselect3.result index 78a75776573..dbfb035eadc 100644 --- a/mysql-test/r/subselect3.result +++ b/mysql-test/r/subselect3.result @@ -841,11 +841,16 @@ x ROW(11, 12) = (SELECT MAX(x), 22) ROW(11, 12) IN (SELECT MAX(x), 22) 1 0 0 2 0 0 11 0 0 -# 2nd and 3rd columns should be same for x == 11 only +# 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; +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY t1 ALL NULL NULL NULL NULL 3 +3 DEPENDENT SUBQUERY NULL NULL NULL NULL NULL NULL NULL No tables used +2 DEPENDENT SUBQUERY NULL NULL NULL NULL NULL NULL NULL No tables used SELECT a AS x, ROW(11, 12) = (SELECT MAX(x), 12), ROW(11, 12) IN (SELECT MAX(x), 12) FROM t1; x ROW(11, 12) = (SELECT MAX(x), 12) ROW(11, 12) IN (SELECT MAX(x), 12) -1 0 1 -2 0 1 +1 0 0 +2 0 0 11 1 1 DROP TABLE t1; # both columns should be same |