From 306371a8508606642bd606aa68b41ad9e3e1fed5 Mon Sep 17 00:00:00 2001
From: "gkodinov/kgeorge@magare.gmz" <>
Date: Fri, 4 May 2007 18:06:06 +0300
Subject: bug #27531: 5.1 part of the fix:  - added join cache indication in
 EXPLAIN (Extra column).  - prefer filesort over full scan over    index for
 ORDER BY (because it's faster).  - when switching from REF to RANGE because  
  RANGE uses longer key turn off sort on    the head table only as the
 resulting    RANGE access is a candidate for join cache    and we don't want
 to disable it by sorting    on the first table only.

---
 mysql-test/r/view.result | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'mysql-test/r/view.result')

diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result
index 8ebf4d40067..cc353f5e1db 100644
--- a/mysql-test/r/view.result
+++ b/mysql-test/r/view.result
@@ -2317,7 +2317,7 @@ id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t2	ref	a	a	10	const,test.t1.b	2	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
+1	SIMPLE	t1	ref	a	a	5	const	1	Using where; Using index; Using join cache
 1	SIMPLE	t3	ALL	NULL	NULL	NULL	NULL	3	Using where
 DROP VIEW v1,v2;
 DROP TABLE t1,t2,t3;
-- 
cgit v1.2.1