# # Test how DROP TABLE works if the index or data file doesn't exists # Initialise --disable_warnings drop table if exists t1,t2; --enable_warnings create table t1 (a int) engine=myisam; let $MYSQLD_DATADIR= `select @@datadir`; --remove_file $MYSQLD_DATADIR/test/t1.MYI drop table if exists t1; create table t1 (a int) engine=myisam; --remove_file $MYSQLD_DATADIR/test/t1.MYI --error ER_BAD_TABLE_ERROR,6 drop table t1; create table t1 (a int) engine=myisam; --remove_file $MYSQLD_DATADIR/test/t1.MYD --error ER_BAD_TABLE_ERROR,6,29 drop table t1; --error ER_BAD_TABLE_ERROR drop table t1;