bk commit into 4.0 tree (1.1468)

Below is the list of changes that have just been committed into a local
4.0 repository of monty. When monty 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://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.1468 03/04/24 02:23:25 monty@xxxxxxxxxxxxxxx +2 -0
  Changed test slightly to make it repeatable
  (There was a problem on some AMD system when the floating point precision 
wasn't accurate enough)

  mysql-test/t/group_by.test
    1.22 03/04/24 02:23:24 monty@xxxxxxxxxxxxxxx +2 -0
    Changed test slightly to make it repeatable

  mysql-test/r/group_by.result
    1.31 03/04/24 02:23:24 monty@xxxxxxxxxxxxxxx +4 -2
    new test result

# 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: monty
# Host: narttu.mysql.fi
# Root: /my/mysql-4.0

--- 1.30/mysql-test/r/group_by.result   Wed Apr 23 21:52:14 2003
+++ 1.31/mysql-test/r/group_by.result   Thu Apr 24 02:23:24 2003
@@ -27,6 +27,8 @@
 INSERT INTO t2 VALUES (1,'name','pass','mail','Y','v','n','adr','1','1','1');
 INSERT INTO t2 VALUES (2,'name','pass','mail','Y','v','n','adr','1','1','1');
 INSERT INTO t2 VALUES (3,'name','pass','mail','Y','v','n','adr','1','1','1');
+INSERT INTO t2 VALUES (4,'name','pass','mail','Y','v','n','adr','1','1','1');
+INSERT INTO t2 VALUES (5,'name','pass','mail','Y','v','n','adr','1','1','1');
 SELECT t2.userid, MIN(t1.score) FROM t1, t2 WHERE t1.userID=t2.userID GROUP BY 
t2.userid;
 userid MIN(t1.score)
 1      1
@@ -47,12 +49,12 @@
 2      2.0
 SELECT t2.userid, MIN(t1.score+0.0) FROM t1, t2 WHERE t1.userID=t2.userID AND 
t1.spID=2  GROUP BY t2.userid ORDER BY NULL;
 userid MIN(t1.score+0.0)
-1      1.0
 2      2.0
+1      1.0
 EXPLAIN SELECT t2.userid, MIN(t1.score+0.0) FROM t1, t2 WHERE 
t1.userID=t2.userID AND t1.spID=2  GROUP BY t2.userid ORDER BY NULL;
 table  type    possible_keys   key     key_len ref     rows    Extra
 t1     ALL     NULL    NULL    NULL    NULL    4       Using where; Using 
temporary
-t2     index   PRIMARY PRIMARY 4       NULL    3       Using where; Using index
+t2     eq_ref  PRIMARY PRIMARY 4       t1.userID       1       Using index
 drop table test.t1,test.t2;
 CREATE TABLE t1 (
 PID int(10) unsigned NOT NULL auto_increment,

--- 1.21/mysql-test/t/group_by.test     Wed Apr 23 21:52:14 2003
+++ 1.22/mysql-test/t/group_by.test     Thu Apr 24 02:23:24 2003
@@ -34,6 +34,8 @@
 INSERT INTO t2 VALUES (1,'name','pass','mail','Y','v','n','adr','1','1','1');
 INSERT INTO t2 VALUES (2,'name','pass','mail','Y','v','n','adr','1','1','1');
 INSERT INTO t2 VALUES (3,'name','pass','mail','Y','v','n','adr','1','1','1');
+INSERT INTO t2 VALUES (4,'name','pass','mail','Y','v','n','adr','1','1','1');
+INSERT INTO t2 VALUES (5,'name','pass','mail','Y','v','n','adr','1','1','1');
 
 SELECT t2.userid, MIN(t1.score) FROM t1, t2 WHERE t1.userID=t2.userID GROUP BY 
t2.userid;
 SELECT t2.userid, MIN(t1.score) FROM t1, t2 WHERE t1.userID=t2.userID GROUP BY 
t2.userid ORDER BY NULL;

-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=gcdmd-internals@xxxxxxxxxxx