bk commit into 3.23 tree

[sasha]

Below is the list of changes that have just been pushed into main
3.23. repository. For information on how to access the repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html
>>>>>>> BitKeeper/tmp/post-commit_sasha@stripped

ChangeSet@stripped, 2001-06-22 15:13:33-06:00, sasha@stripped
  added test case for the bug in ORDER BY when we fill up sort buffer
  Note that if you change sort buffer to be bigger, the bug will not show

  mysql-test/r/order_fill_sortbuf.result
    1.1 01/06/22 15:13:32 sasha@stripped +2 -0

  mysql-test/t/order_fill_sortbuf-master.opt
    1.1 01/06/22 15:13:32 sasha@stripped +1 -0

  mysql-test/t/order_fill_sortbuf.test
    1.1 01/06/22 15:13:32 sasha@stripped +19 -0

  mysql-test/r/order_fill_sortbuf.result
    1.0 01/06/22 15:13:32 sasha@stripped +0 -0
    BitKeeper file /home/sasha/src/bk/mysql-4.0/mysql-test/r/order_fill_sortbuf.result

  mysql-test/t/order_fill_sortbuf-master.opt
    1.0 01/06/22 15:13:32 sasha@stripped +0 -0
    BitKeeper file /home/sasha/src/bk/mysql-4.0/mysql-test/t/order_fill_sortbuf-master.opt

  mysql-test/t/order_fill_sortbuf.test
    1.0 01/06/22 15:13:32 sasha@stripped +0 -0
    BitKeeper file /home/sasha/src/bk/mysql-4.0/mysql-test/t/order_fill_sortbuf.test

# 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:	sasha
# Host:	mysql.sashanet.com
# Root:	/home/sasha/src/bk/mysql-4.0
--- New file ---
+++ mysql-test/r/order_fill_sortbuf.result	01/06/22 15:13:32
count(*)
4000

--- New file ---
+++ mysql-test/t/order_fill_sortbuf-master.opt	01/06/22 15:13:32
-O sort_buffer=0

--- New file ---
+++ mysql-test/t/order_fill_sortbuf.test	01/06/22 15:13:32
drop table if exists t1,t2;
CREATE TABLE `t1` (
  `id` int(11) NOT NULL default '0',
  `id2` int(11) NOT NULL default '0',
  `id3` int(11) NOT NULL default '0',
  `dummy1` char(30) default NULL,
  PRIMARY KEY  (`id`,`id2`),
  KEY `index_id3` (`id3`));
let $1=4000;
while ($1)
 {
   eval insert into t1 (id,id2,id3,dummy1) values ($1,$1,$1,'foobar');
   dec $1;
 }

create table t2 (n int);
insert into t2 select id2 from t1 order by id3;
select count(*) from t2;
drop table t1,t2;