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_mat_cost.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_mat_cost.result')
| -rw-r--r-- | mysql-test/r/subselect_mat_cost.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/subselect_mat_cost.result b/mysql-test/r/subselect_mat_cost.result index 003d7b0231b..3f465f1a7d0 100644 --- a/mysql-test/r/subselect_mat_cost.result +++ b/mysql-test/r/subselect_mat_cost.result @@ -247,7 +247,7 @@ AND CountryLanguage.Language = 'French' AND Code = Country; id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY CountryLanguage ref PRIMARY,Language Language 30 const 20 Using index condition -1 PRIMARY Country eq_ref PRIMARY PRIMARY 3 world.CountryLanguage.Country 1 Using index condition +1 PRIMARY Country eq_ref PRIMARY PRIMARY 3 world.CountryLanguage.Country 1 Using where 2 DEPENDENT SUBQUERY CountryLanguage unique_subquery PRIMARY,Language PRIMARY 33 func,const 1 Using index; Using where SELECT Country.Name FROM Country, CountryLanguage @@ -286,7 +286,7 @@ AND (CountryLanguage.Language = 'French' OR CountryLanguage.Language = 'Spanish' AND Code = Country; id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY CountryLanguage range PRIMARY,Language Language 30 NULL 45 Using index condition; Using where; Rowid-ordered scan -1 PRIMARY Country eq_ref PRIMARY PRIMARY 3 world.CountryLanguage.Country 1 Using index condition +1 PRIMARY Country eq_ref PRIMARY PRIMARY 3 world.CountryLanguage.Country 1 Using where 2 MATERIALIZED CountryLanguage ref PRIMARY,Language Language 30 const 47 Using index condition SELECT Country.Name FROM Country, CountryLanguage |