~drizzle-trunk/drizzle/development

#

# SELECT IN () with NULL in IN changes query plan

#

# http://bugs.mysql.com/bug.php?id=44139

# 

drop table if exists foo;

create temporary table foo (

	a int not null auto_increment,

	b int,

	primary key( a )

) engine=myisam;

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;

explain select * from foo where a in (160000, 160001, 160002);

explain select * from foo where a in (null, 160000, 160001, 160002);

DROP TABLE foo;