[MDEV-23185] CREATE OR REPLACE TABLE is less robust than DROP TABLE + CREATE TABLE - Jira

Starting from 10.5, DROP TABLE works even if a .frm file is missing. But CREATE OR REPLACE TABLE doesn't:

MariaDB [test]> CREATE TABLE x (a int);

Query OK, 0 rows affected (0.009 sec)

MariaDB [test]> \! ls -1 /var/lib/mysql/test/x.*

/var/lib/mysql/test/x.frm

/var/lib/mysql/test/x.ibd

MariaDB [test]> \! rm /var/lib/mysql/test/x.frm

MariaDB [test]> CREATE OR REPLACE TABLE x (a int);

ERROR 1813 (HY000): Tablespace for table '`test`.`x`' exists. Please DISCARD the tablespace before IMPORT

MariaDB [test]> DROP TABLE x;

Query OK, 0 rows affected (0.006 sec)

If this is not a bug, please consider it as a feature request.

relates to

MDEV-11412 Ensure that table is truly dropped when using DROP TABLE

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server