List:Commits« Previous MessageNext Message »
From:Jonas Oreland Date:November 10 2010 10:05am
Subject:bzr commit into mysql-5.1-telco-7.0-spj-scan-vs-scan branch (jonas:3357)
View as plain text  
#At file:///home/jonas/src/70-spj-svs/ based on revid:jonas@stripped

 3357 Jonas Oreland	2010-11-10
      ndb spj svs - fix result (explain) missmatch...

    modified:
      mysql-test/suite/ndb/r/ndb_condition_pushdown.result
=== modified file 'mysql-test/suite/ndb/r/ndb_condition_pushdown.result'
--- a/mysql-test/suite/ndb/r/ndb_condition_pushdown.result	2010-11-10 08:01:00 +0000
+++ b/mysql-test/suite/ndb/r/ndb_condition_pushdown.result	2010-11-10 10:05:24 +0000
@@ -2154,7 +2154,7 @@ insert into t values (0,0),(1,1),(2,2),(
 set engine_condition_pushdown = on;
 explain select * from t where 3 between 1+1 and x order by pk;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t	ALL	NULL	NULL	NULL	NULL	6	Using where; Using filesort
+1	SIMPLE	t	index	NULL	PRIMARY	4	NULL	6	Using where
 select * from t where 3 between 1+1 and x order by pk;
 pk	x
 3	3
@@ -2162,7 +2162,7 @@ pk	x
 5	5
 explain select * from t where 3 between -1 and x order by pk;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t	ALL	NULL	NULL	NULL	NULL	6	Using where; Using filesort
+1	SIMPLE	t	index	NULL	PRIMARY	4	NULL	6	Using where
 select * from t where 3 between -1 and x order by pk;
 pk	x
 3	3


Attachment: [text/bzr-bundle] bzr/jonas@mysql.com-20101110100524-d8l0iteoagp5r4rf.bundle
Thread
bzr commit into mysql-5.1-telco-7.0-spj-scan-vs-scan branch (jonas:3357) Jonas Oreland10 Nov