~drizzle-trunk/drizzle/development

select_in_null test was attempting DDL inside txn. remove begin/commit as it's not needed anyway

added added

removed removed

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;

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