Reproduce
--source include/have_perfschema.inc
|
|
create or replace table yt4 (x int);
|
alter table yt4 rename to t1, algorithm=copy;
|
drop tables t1;
|
|
SELECT object_type, object_schema, object_name
|
FROM performance_schema.objects_summary_global_by_type
|
WHERE object_schema="test";
|
Result
object_type object_schema object_name
|
TABLE test yt4
|
Expected
Empty resultset.
Notes
10.3, 10.4 look good:
create or replace table yt4 (x int);
|
alter table yt4 rename to t1, algorithm=copy;
|
drop tables t1;
|
SELECT object_type, object_schema, object_name
|
FROM performance_schema.objects_summary_global_by_type
|
WHERE object_schema="test";
|
object_type object_schema object_name
|
algorithm=inplace on 10.5 looks good:
create or replace table yt4 (x int) engine innodb;
|
alter table yt4 rename to t1, algorithm=inplace;
|
drop tables t1;
|
SELECT object_type, object_schema, object_name
|
FROM performance_schema.objects_summary_global_by_type
|
WHERE object_schema="test";
|
object_type object_schema object_name
|
Bug
Major
MDEV-21053
Crash safety of foreign key DDL
