From 3088f6c7ba361b1baa8de649d7ff32ed1f2293d4 Mon Sep 17 00:00:00 2001 From: Guilhem Bichot Date: Mon, 19 Oct 2009 15:14:43 +0200 Subject: Back-port from 6.0 of the fix for BUG#38049 "incorrect rows estimations with references from preceding table" (from revid:sergefp@mysql.com-20090126194259-ue20il3qro529l4d). Compared to 6.0 where EXPLAIN indicates "Using index condition", here in join_optimizer.result we see "Using where"; it's normal; 6.0 shows the same if disabling Index Condition Pushdown. --- mysql-test/r/view.result | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'mysql-test/r/view.result') diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index e23e8930ddb..69bcf349f51 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -2342,11 +2342,11 @@ CREATE VIEW v2 AS SELECT t3.* FROM t1,t3 WHERE t1.a=t3.a; EXPLAIN SELECT t1.* FROM t1 JOIN t2 WHERE t1.a=t2.a AND t1.b=t2.b AND t1.a=1; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref a a 5 const 1 Using where; Using index -1 SIMPLE t2 ref a a 10 const,test.t1.b 2 Using where; Using index +1 SIMPLE t2 ref a a 10 const,test.t1.b 1 Using where; Using index EXPLAIN SELECT * FROM v1 WHERE a=1; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref a a 5 const 1 Using where; Using index -1 SIMPLE t2 ref a a 10 const,test.t1.b 2 Using where; Using index +1 SIMPLE t2 ref a a 10 const,test.t1.b 1 Using where; Using index EXPLAIN SELECT * FROM v2 WHERE a=1; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref a a 5 const 1 Using where; Using index -- cgit v1.2.1