bk commit into 5.0 tree (timour:1.2246)

[timour]

Below is the list of changes that have just been committed into a local
5.0 repository of timka. When timka 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@stripped, 2006-08-23 17:13:01+03:00, timour@stripped +1 -0
  post-merge fix for BUG 21456

  mysql-test/r/distinct.result@stripped, 2006-08-23 17:12:59+03:00, timour@stripped +11 -0
    post-merge fix for BUG 21456

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	timour
# Host:	lamia.home
# Root:	/home/timka/mysql/src/5.0-bug-21456

--- 1.47/mysql-test/r/distinct.result	2006-08-23 17:13:04 +03:00
+++ 1.48/mysql-test/r/distinct.result	2006-08-23 17:13:04 +03:00
@@ -563,6 +563,17 @@ id	IFNULL(dsc, '-')
 2	line number two
 3	line number three
 drop table t1;
+CREATE TABLE t1 (a int primary key, b int);
+INSERT INTO t1 (a,b) values (1,1), (2,3), (3,2);
+explain SELECT DISTINCT a, b FROM t1 ORDER BY b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	Using filesort
+SELECT DISTINCT a, b FROM t1 ORDER BY b;
+a	b
+1	1
+3	2
+2	3
+DROP TABLE t1;
 CREATE TABLE t1 (
 ID int(11) NOT NULL auto_increment,
 x varchar(20) default NULL,