List:Commits« Previous MessageNext Message »
From:Tor Didriksen Date:September 29 2010 12:49pm
Subject:bzr commit into mysql-next-mr-bugfixing branch (tor.didriksen:3305) Bug#50394
View as plain text  
#At file:///export/home/didrik/repo/next-mr-bf/ based on revid:alik@stripped

 3305 Tor Didriksen	2010-09-29
      Bug#50394 Regression in EXPLAIN with index scan, LIMIT, GROUP BY and ORDER BY computed col
     @ mysql-test/r/join_cache_jcl1.result
        Correct the rows estimate.

    modified:
      mysql-test/r/join_cache_jcl1.result
=== modified file 'mysql-test/r/join_cache_jcl1.result'
--- a/mysql-test/r/join_cache_jcl1.result	2010-09-20 15:05:13 +0000
+++ b/mysql-test/r/join_cache_jcl1.result	2010-09-29 12:49:37 +0000
@@ -2219,7 +2219,7 @@ GROUP BY t1.col_int_key
 ORDER BY t1.col_int_key, t1.col_datetime
 LIMIT 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	index	NULL	col_int_key	5	NULL	2	Using temporary; Using filesort
+1	SIMPLE	t1	index	NULL	col_int_key	5	NULL	3	Using temporary; Using filesort
 1	SIMPLE	t2	ref	col_int_key	col_int_key	5	const	1	Using where
 SELECT t1.col_int_key, t1.col_datetime 
 FROM t1,t2


Attachment: [text/bzr-bundle] bzr/tor.didriksen@oracle.com-20100929124937-z52asb85dcq10wff.bundle
Thread
bzr commit into mysql-next-mr-bugfixing branch (tor.didriksen:3305) Bug#50394Tor Didriksen29 Sep