create table ... as select ... results in ghost tdc if opening the table fails

If

create table ... as select ...

fails at opening the table, then it does not clear the table from the
table cache, and a subsequent create table with the same name would
fail with 1050 ER_TABLE_EXISTS_ERROR, while a subsequent drop table
with the same name would fail with 1051 ER_BAD_TABLE_ERROR.

Here's an example with spider at 11.4
4c9fd4f45b2be8f446777bf470e9352cd3e7c092, but presumably any table
creation failing at opening the table in any version should suffice:

install soname 'ha_spider';

set spider_same_server_link= 1;

evalp CREATE SERVER srv FOREIGN DATA WRAPPER mysql

OPTIONS (SOCKET "$MASTER_1_MYSOCK", DATABASE 'test',user 'root');

--error 1205

create table t (c int) engine=spider comment='srv "srv"' as select 1;

# fails with error 1050 ER_TABLE_EXISTS_ERROR

# create table t (c int);

# fails with error 1051 ER_BAD_TABLE_ERROR

# drop table t;

# also fails with error 1051 ER_BAD_TABLE_ERROR

# create or replace table t (c int);