DROP TABLE IF EXISTS t1,T1; CREATE TABLE t1 (a int); SELECT * from T1; a drop table t1; flush tables; CREATE TABLE bug29839 (a int) ENGINE=INNODB; SELECT * from BUG29839; ERROR 42S02: Table 'test.BUG29839' doesn't exist drop table bug29839;