diff options
Diffstat (limited to 'mysql-test/main/subselect_mat_cost.test')
| -rw-r--r-- | mysql-test/main/subselect_mat_cost.test | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/subselect_mat_cost.test b/mysql-test/main/subselect_mat_cost.test index 8fe38849735..12263e75cfc 100644 --- a/mysql-test/main/subselect_mat_cost.test +++ b/mysql-test/main/subselect_mat_cost.test @@ -73,13 +73,13 @@ set @@optimizer_switch = 'in_to_exists=on,semijoin=on,materialization=on,partial -- echo Q1.1m: -- echo MATERIALIZATION: there are too many rows in the outer query -- echo to be looked up in the inner table. -EXPLAIN +set statement optimizer_cache_hit_ratio=20 for EXPLAIN SELECT Name FROM Country WHERE (Code IN (select Country from City where City.Population > 100000) OR Name LIKE 'L%') AND surfacearea > 1000000; -SELECT Name FROM Country +set statement optimizer_cache_hit_ratio=20 for SELECT Name FROM Country WHERE (Code IN (select Country from City where City.Population > 100000) OR Name LIKE 'L%') AND surfacearea > 1000000; @@ -210,7 +210,6 @@ WHERE Code NOT IN (SELECT Country FROM CountryLanguage WHERE Language = 'English -- echo MATERIALIZATION because the outer query filters less rows than Q5-a, -- echo so there are more lookups. - set statement optimizer_switch='rowid_filter=off' for EXPLAIN SELECT Country.Name @@ -369,6 +368,7 @@ drop index CountryCapital on Country; # TODO: the cost estimates for subqueries in the HAVING clause need to be changed # to take into account that the subquery predicate is executed #times ~ to the # number of groups, not number of rows + EXPLAIN SELECT City.Name, City.Population FROM City JOIN Country ON City.Country = Country.Code |