~drizzle-trunk/drizzle/development

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
drop table if exists foo;
Warnings:
Note	1051	Unknown table 'foo'
create temporary table foo (
a int not null auto_increment,
b int,
primary key( a )
) engine=myisam;
begin;
insert into foo( b ) values (1),(1),(1),(1),(1);
create table t2 as select * from foo;
insert into foo( b ) select b from t2;
drop table t2;
create table t2 as select * from foo;
insert into foo( b ) select b from t2;
drop table t2;
create table t2 as select * from foo;
insert into foo( b ) select b from t2;
drop table t2;
create table t2 as select * from foo;
insert into foo( b ) select b from t2;
drop table t2;
create table t2 as select * from foo;
insert into foo( b ) select b from t2;
drop table t2;
commit;
explain select * from foo where a in (160000, 160001, 160002);
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	foo	range	PRIMARY	PRIMARY	4	NULL	3	Using where
explain select * from foo where a in (null, 160000, 160001, 160002);
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	foo	range	PRIMARY	PRIMARY	4	NULL	3	Using where
DROP TABLE foo;