List:Commits« Previous MessageNext Message »
From:Mattias Jonsson Date:September 11 2009 11:29pm
Subject:bzr commit into mysql-pe branch (mattias.jonsson:3602) Bug#20577
Bug#46362
View as plain text  
#At file:///Users/mattiasj/clones/bzrroot/topush-mysql-pe/ based on revid:mattias.jonsson@stripped

 3602 Mattias Jonsson	2009-09-12
      post push fix for mysql-pe for bug#20577 and bug#46362.
      
      fix for mysql-pe; 'Using where' should not be in the extra column after MRR and other optimizer changes.
     @ mysql-test/r/partition_pruning.result
        post push fix for mysql-pe for bug#20577 and bug#46362.
        
        fix for mysql-pe; 'Using where' should not be in the extra column after MRR and other optimizer changes.

    modified:
      mysql-test/r/partition_pruning.result
=== modified file 'mysql-test/r/partition_pruning.result'
--- a/mysql-test/r/partition_pruning.result	2009-09-01 14:04:56 +0000
+++ b/mysql-test/r/partition_pruning.result	2009-09-11 23:29:44 +0000
@@ -137,7 +137,7 @@ id	select_type	table	partitions	type	pos
 1	SIMPLE	t1	pNULL,p1001-01-01,p2001-01-01	range	a	a	4	NULL	4	Using where; Using index
 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a = '1001-00-00';
 id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	pNULL	ref	a	a	4	const	1	Using where; Using index
+1	SIMPLE	t1	pNULL	ref	a	a	4	const	1	Using index
 # Disabling warnings for the invalid date
 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a < '1999-02-31';
 id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	Extra
@@ -466,7 +466,7 @@ id	select_type	table	partitions	type	pos
 1	SIMPLE	t1	p2001-01-01,pNULL,p1001-01-01	range	a	a	4	NULL	4	Using where; Using index
 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a = '1001-00-00';
 id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	pNULL	ref	a	a	4	const	1	Using where; Using index
+1	SIMPLE	t1	pNULL	ref	a	a	4	const	1	Using index
 # Disabling warnings for the invalid date
 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a < '1999-02-31';
 id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	Extra


Attachment: [text/bzr-bundle]
Thread
bzr commit into mysql-pe branch (mattias.jonsson:3602) Bug#20577Bug#46362Mattias Jonsson12 Sep