ER_DUP_KEY in mysql.innodb_table_stats upon RENAME on sequence

--source include/have_innodb.inc

set global innodb_stats_persistent= on;

CREATE SEQUENCE s1 ENGINE=InnoDB;

CREATE SEQUENCE s2 ENGINE=InnoDB;

SHOW CREATE SEQUENCE s1;

SHOW CREATE SEQUENCE s2;

DROP SEQUENCE s2;

RENAME TABLE s1 TO s2;

# Cleanup

DROP SEQUENCE s2;

mysqltest: At line 10: query 'RENAME TABLE s1 TO s2' failed: ER_DUP_KEY (1022): Can't write; duplicate key in table 'mysql.innodb_table_stats'

commit 1bd681c8b3c5213ce1f7976940a7dc38b48a0d39

Author: Marko Mäkelä

Date:   Wed Jun 9 17:02:55 2021 +0300

    MDEV-25506 (3 of 3): Do not delete .ibd files before commit