# # Test of heap tables. # --disable_warnings drop table if exists t1,t2,t3; --enable_warnings create table t1 (a int not null) engine=heap; insert into t1 values (869751),(736494),(226312),(802616); alter table t1 add unique uniq_id(a); alter table t1 engine=myisam; explain select * from t1 where a in (869751,736494,226312,802616); drop table t1;