bk commit into 5.1 tree (anozdrin:1.2601) BUG#31035

From: Alexander Nozdrin <alik(at)mysql.com>
Date: Wed Oct 31 2007 - 02:54:03 EDT

Below is the list of changes that have just been committed into a local 5.1 repository of alik. When alik does a push these changes will be propagated to the main repository and, within 24 hours after the push, to the public repository.
For information on how to access the public repository see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@1.2601, 2007-10-31 09:53:58+03:00, anozdrin@station. +2 -0   Fix result files after patch for BUG#31035.

  mysql-test/r/group_min_max.result@1.35, 2007-10-31 09:53:56+03:00, anozdrin@station. +2 -2     Update result file.

  mysql-test/r/index_merge_myisam.result@1.9, 2007-10-31 09:53:56+03:00, anozdrin@station. +1 -1     Update result file.

diff -Nrup a/mysql-test/r/group_min_max.result b/mysql-test/r/group_min_max.result
--- a/mysql-test/r/group_min_max.result 2007-08-02 23:45:48 +04:00
+++ b/mysql-test/r/group_min_max.result 2007-10-31 09:53:56 +03:00 @@ -2251,7 +2251,7 @@ EXPLAIN SELECT 1 FROM t1 AS t1_outer WHE  (SELECT max(b) FROM t1 GROUP BY a HAVING a < 2) > 12;

 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	PRIMARY	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Impossible WHERE

-2	SUBQUERY	t1	range	NULL	a	5	NULL	8	Using index for group-by

+2	SUBQUERY	t1	range	NULL	a	5	NULL	8	

 EXPLAIN SELECT 1 FROM t1 AS t1_outer WHERE  a IN (SELECT max(b) FROM t1 GROUP BY a HAVING a < 2);  id select_type table type possible_keys key key_len ref rows Extra @@ -2268,7 +2268,7 @@ AND t1_outer1.b = t1_outer2.b;

 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	PRIMARY	t1_outer1	ref	a	a	5	const	1	Using where; Using index
 1	PRIMARY	t1_outer2	index	NULL	a	10	NULL	15	Using where; Using index; Using join buffer

-2	SUBQUERY	t1	range	NULL	a	5	NULL	8	Using index for group-by

+2	SUBQUERY	t1	range	NULL	a	5	NULL	8	

 EXPLAIN SELECT (SELECT (SELECT max(b) FROM t1 GROUP BY a HAVING a < 2) x  FROM t1 AS t1_outer) x2 FROM t1 AS t1_outer2;  id select_type table type possible_keys key key_len ref rows Extra diff -Nrup a/mysql-test/r/index_merge_myisam.result b/mysql-test/r/index_merge_myisam.result
--- a/mysql-test/r/index_merge_myisam.result 2007-07-18 19:08:02 +04:00

+++ b/mysql-test/r/index_merge_myisam.result	2007-10-31 09:53:56 +03:00
@@ -286,7 +286,7 @@ NULL	UNION RESULT		ALL	NULL	NU
 explain select * from (select * from t1 where key1 = 3 or key2 =3) as Z where key8 >5;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	PRIMARY		system	NULL	NULL	NULL	NULL	1	

-2	DERIVED	t1	index_merge	i1,i2	i1,i2	4,4	NULL	2	Using union(i1,i2); Using where; Using index

+2	DERIVED	t1	index_merge	i1,i2	i1,i2	4,4	NULL	2	Using union(i1,i2); Using where

 create table t3 like t0;
 insert into t3 select * from t0;
 alter table t3 add key9 int not null, add index i9(key9);

--

MySQL Code Commits Mailing List
For list archives: http://lists.mysql.com/commits To unsubscribe: http://lists.mysql.com/commits?unsub=lists@pantek.com Received on Wed Oct 31 02:52:14 2007