diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-12-18 23:38:37 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-12-18 23:38:37 -0800 |
| commit | 7a1406f229df002befeb91f39f57e15444aecb21 (patch) | |
| tree | 42a7ecb4198e90a067b21f4cede12cc08dea28c5 /mysql-test/r/subselect.result | |
| parent | 2bfd02cea95a774dbc82b51fafa2bf727b9bb0ff (diff) | |
| download | mariadb-git-7a1406f229df002befeb91f39f57e15444aecb21.tar.gz | |
Fixed LP bug #904832.
Do not perform index condition pushdown for conditions containing subqueries
and stored functions.
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 58a4e61ce0b..8008d887823 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -1374,7 +1374,7 @@ create table t1 (id int not null auto_increment primary key, salary int, key(sal insert into t1 (salary) values (100),(1000),(10000),(10),(500),(5000),(50000); explain extended SELECT id FROM t1 where salary = (SELECT MAX(salary) FROM t1); id select_type table type possible_keys key key_len ref rows filtered Extra -1 PRIMARY t1 ref salary salary 5 const 0 0.00 Using index condition +1 PRIMARY t1 ref salary salary 5 const 0 0.00 Using where 2 SUBQUERY NULL NULL NULL NULL NULL NULL NULL NULL Select tables optimized away Warnings: Note 1003 select `test`.`t1`.`id` AS `id` from `test`.`t1` where (`test`.`t1`.`salary` = (select max(`test`.`t1`.`salary`) from `test`.`t1`)) |