Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5
-
None
Description
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
|
Attachments
Issue Links
- relates to
-
MDEV-21053 Crash safety of foreign key DDL
- Stalled