EVOLUTION-MANAGER

Edit File: order_fill_sortbuf.test

# # This test does a create-select with ORDER BY, where there is so many # rows MySQL needs to use a merge during the sort phase. # --disable_warnings drop table if exists t1,t2; --enable_warnings set @@sort_buffer_size=32804; CREATE TABLE `t1` ( `id` int(11) NOT NULL default '0', `id2` int(11) NOT NULL default '0', `id3` int(11) NOT NULL default '0'); let $1=4000; --disable_query_log begin; while ($1) { eval insert into t1 (id,id2,id3) values ($1,$1,$1); dec $1; } commit; --enable_query_log create table t2 select id2 from t1 order by id3; select count(*) from t2; drop table t1,t2; # End of 4.1 tests