CREATE SCHEMA bug74331;
SHOW FULL TABLES FROM `bug74331` WHERE `Tables_in_bug74331` = 'foo';
Tables_in_bug74331	Table_type
DROP SCHEMA bug74331;