diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-11-01 07:00:55 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-11-01 07:00:55 -0700 |
| commit | a70f7aa5fe0b05228aea5bf9673233d857524b0d (patch) | |
| tree | 53f7e1eafa2d490add5166bf90281c65f1113187 /mysql-test/r/subselect_no_semijoin.result | |
| parent | 0efacfcfb24443bbd342e5c4447b166cb569438c (diff) | |
| download | mariadb-git-a70f7aa5fe0b05228aea5bf9673233d857524b0d.tar.gz | |
Backported the fix and the test case for bug 12822678 from the mysql-5.6 code line.
Fixed a bug in select_describe.
Adjusted results for affected test cases.
Diffstat (limited to 'mysql-test/r/subselect_no_semijoin.result')
| -rw-r--r-- | mysql-test/r/subselect_no_semijoin.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/subselect_no_semijoin.result b/mysql-test/r/subselect_no_semijoin.result index 8d1681764e6..44433d62ccd 100644 --- a/mysql-test/r/subselect_no_semijoin.result +++ b/mysql-test/r/subselect_no_semijoin.result @@ -370,7 +370,7 @@ EXPLAIN EXTENDED SELECT pseudo,(SELECT email FROM t8 WHERE pseudo=(SELECT pseudo id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY t8 const PRIMARY PRIMARY 37 const 1 100.00 Using where; Using index 4 SUBQUERY t8 const PRIMARY PRIMARY 37 const 1 100.00 Using index -2 SUBQUERY t8 const PRIMARY PRIMARY 37 const 1 100.00 Using index condition +2 SUBQUERY t8 const PRIMARY PRIMARY 37 const 1 100.00 Using where 3 SUBQUERY t8 const PRIMARY PRIMARY 37 const 1 100.00 Using index Warnings: Note 1003 select `test`.`t8`.`pseudo` AS `pseudo`,(select `test`.`t8`.`email` from `test`.`t8` where (`test`.`t8`.`pseudo` = (select 'joce' from `test`.`t8` where 1))) AS `(SELECT email FROM t8 WHERE pseudo=(SELECT pseudo FROM t8 WHERE pseudo='joce'))` from `test`.`t8` where (`test`.`t8`.`pseudo` = (select 'joce' from `test`.`t8` where 1)) |