|
1
by brian
clean slate |
1 |
#
|
2 |
# This test does a create-select with ORDER BY, where there is so many
|
|
3 |
# rows MySQL needs to use a merge during the sort phase.
|
|
4 |
#
|
|
5 |
||
6 |
--disable_warnings |
|
7 |
drop table if exists t1,t2; |
|
8 |
--enable_warnings |
|
9 |
||
10 |
CREATE TABLE `t1` ( |
|
11 |
`id` int(11) NOT NULL default '0', |
|
12 |
`id2` int(11) NOT NULL default '0', |
|
13 |
`id3` int(11) NOT NULL default '0'); |
|
14 |
let $1=4000; |
|
15 |
disable_query_log; |
|
16 |
while ($1) |
|
17 |
{
|
|
18 |
eval insert into t1 (id,id2,id3) values ($1,$1,$1); |
|
19 |
dec $1; |
|
20 |
}
|
|
21 |
enable_query_log; |
|
22 |
create table t2 select id2 from t1 order by id3; |
|
23 |
select count(*) from t2; |
|
24 |
drop table t1,t2; |
|
25 |
||
26 |
# End of 4.1 tests
|