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;
|