[MDEV-36501] EITS data is lost after failed attempt to CREATE OR REPLACE table - Jira

Quite possibly it is intentional and/or unavoidable, but if so, it should probably reflected in MTR tests, and I couldn't see it.

create table t (a int primary key);

insert into t values (1),(2);

analyze table t persistent for all;

select count(*) from mysql.table_stats where table_name = 't';

select count(*) from mysql.index_stats where table_name = 't';

select count(*) from mysql.column_stats where table_name = 't';

--error ER_DUP_ENTRY

create or replace table t (b int primary key) as select 1 as b union all select 1;

select * from t;

select count(*) from mysql.table_stats where table_name = 't';

select count(*) from mysql.index_stats where table_name = 't';

select count(*) from mysql.column_stats where table_name = 't';

drop table t;

bb-main-monty 2931f8e3a7f4871ef2a82262dc78d5162837b738
create or replace table t (b int primary key) as select 1 as b union all select 1;
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
select * from t;
a
1
2
select count(*) from mysql.table_stats where table_name = 't';
count(*)
0
select count(*) from mysql.index_stats where table_name = 't';
count(*)
0
select count(*) from mysql.column_stats where table_name = 't';
count(*)
0

So, CREATE OR REPLACE is atomic as expected, the table and its contents remain intact, but the statistical data is gone.

is caused by

MDEV-25292 Atomic CREATE OR REPLACE TABLE

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

MariaDB Server