List:Commits« Previous MessageNext Message »
From:Mauritz Sundell Date:August 28 2011 7:41pm
Subject:bzr push into mysql-5.1-telco-7.0 branch (mauritz.sundell:4483 to 4485)
View as plain text  
 4485 Mauritz Sundell	2011-08-28
      Regenerated (again) test result fro ndb_statistics1 with notes.
      
      Wrong result committed - stupid me.
      
      Three query plans changed but is equally good as the previous.
      A test related to bug #59519 seems broken even before the
      previus commit. The query plan should have >1 row in last join.
      
      In the same query the index for (I,J) should be choosen but
      in this case the resulting index (J,K) is equally good.

    modified:
      mysql-test/suite/ndb/r/ndb_statistics1.result
 4484 Mauritz Sundell	2011-08-28
      Regenerated test result fro ndb_statistics1 with notes.
      
      Three query plans changed but is equally good as the previous.
      A test related to bug #59519 seems broken even before the
      previus commit. The query plan should have >1 row in last join.
      
      In the same query the index for (I,J) should be choosen but
      in this case the resulting index (J,K) is equally good.

    modified:
      mysql-test/suite/ndb/r/ndb_statistics1.result
 4483 Mauritz Sundell	2011-08-28
      ndb - index statistics for partial keys of unique/primary ordered index

    modified:
      mysql-test/suite/ndb/r/ndb_index_stat.result
      mysql-test/suite/ndb/t/ndb_index_stat.test
      sql/ha_ndbcluster.cc
=== modified file 'mysql-test/suite/ndb/r/ndb_statistics1.result'
--- a/mysql-test/suite/ndb/r/ndb_statistics1.result	2011-07-25 17:11:41 +0000
+++ b/mysql-test/suite/ndb/r/ndb_statistics1.result	2011-08-28 18:21:59 +0000
@@ -77,7 +77,7 @@ SELECT * FROM t10000 AS X JOIN t10000 AS
 ON Y.I=X.I AND Y.J = X.I;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	X	ALL	I	NULL	NULL	NULL	10000	
-1	SIMPLE	Y	ref	J,I	I	10	test.X.I,test.X.I	1	Using where
+1	SIMPLE	Y	ref	J,I	J	5	test.X.I	1	Using where
 EXPLAIN
 SELECT * FROM t100 WHERE k < 42;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
@@ -145,11 +145,11 @@ id	select_type	table	type	possible_keys
 EXPLAIN
 SELECT * FROM t10000 WHERE J = 0 AND K < 1;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t10000	range	PRIMARY,J	PRIMARY	4	NULL	2	Using where with pushed condition
+1	SIMPLE	t10000	ref	PRIMARY,J	J	5	const	2	Using where with pushed condition
 EXPLAIN
 SELECT * FROM t10000 WHERE J = 0 AND K BETWEEN 1 AND 10;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t10000	range	PRIMARY,J	PRIMARY	4	NULL	2	Using where with pushed condition
+1	SIMPLE	t10000	ref	PRIMARY,J	J	5	const	2	Using where with pushed condition
 EXPLAIN
 SELECT * FROM t10000 WHERE J = 0 AND K = 1;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

No bundle (reason: useless for push emails).
Thread
bzr push into mysql-5.1-telco-7.0 branch (mauritz.sundell:4483 to 4485) Mauritz Sundell29 Aug