ERROR 1062 (23000): Duplicate entry 'test-t-0' for key 'PRIMARY' on CoR for Spider table, DDL_LOG: Got error 1032 or 12524 when trying to execute action for entry 1/2/3/4/5/6/7 of type 'rename table'

INSTALL PLUGIN Spider SONAME 'ha_spider.so';

CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET'',DATABASE'',USER'',PASSWORD 'PWD0');

CREATE TABLE t (a INT KEY AUTO_INCREMENT) ENGINE=Spider COMMENT='WRAPPER "mysql",srv "srv",TABLE "t"';

ALTER TABLE t ADD b TEXT;

CREATE OR REPLACE TABLE t (a INT) ENGINE=Spider;

10.11.0-opt>CREATE OR REPLACE TABLE t (a INT) ENGINE=Spider;

ERROR 1062 (23000): Duplicate entry 'test-t-0' for key 'PRIMARY'

2022-10-15 16:40:29 25 [Warning] Access denied for user ''@'localhost' (using password: YES)

2022-10-15 16:40:29 4 [ERROR] mysqld: Can't find record in 'spider_tables'

2022-10-15 16:40:29 4 [ERROR] DDL_LOG: Got error 1032 when trying to execute action for entry 6 of type 'rename table'