InnoDB skips the tablespace in rotation list

-- source include/have_innodb.inc

-- source include/not_embedded.inc

-- source include/have_example_key_management_plugin.inc

set global innodb_encrypt_tables=0;

CREATE TABLE t1 (f1 INT, f2 VARCHAR(256))engine=innodb;

INSERT INTO t1 VALUES(1, 'MariaDB'), (2, 'Robot'), (3, 'Science');

INSERT INTO t1 SELECT * FROM t1;

CREATE TABLE t2(f1 INT, f2 VARCHAR(256))engine=innodb;

INSERT INTO t2 SELECT * FROM t1;

let $restart_parameters=--innodb_encrypt_tables=1;

--source include/restart_mysqld.inc

set global innodb_encrypt_tables=1;

SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;

NAME

innodb_system

SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;

NAME

drop table t2, t1;