#
# Bug #29492911 : ENABLING UNDO-TABLESPACE ENCRYPTION DOESN'T MARK TABLESPACE ENCRYPTION FLAG
#
SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
Variable_name	Value
innodb_undo_log_encrypt	OFF
###############################################################################
# With keyring plugin and innodb_undo_log_encrypt=ON
###############################################################################
SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
Variable_name	Value
innodb_undo_log_encrypt	ON
# Create a new UNDO tablespace. Should be created as ENCRYPTED.
CREATE UNDO TABLESPACE undo_3 ADD DATAFILE 'undo_3.ibu';
SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
NAME	SPACE_TYPE	ENCRYPTION	STATE
innodb_undo_001	Undo	Y	active
innodb_undo_002	Undo	Y	active
innodb_undo_003	Undo	Y	active
innodb_undo_004	Undo	Y	active
innodb_undo_005	Undo	Y	active
innodb_undo_006	Undo	Y	active
undo_3	Undo	Y	active
SET GLOBAL innodb_undo_log_encrypt=OFF;
SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
Variable_name	Value
innodb_undo_log_encrypt	OFF
SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
NAME	SPACE_TYPE	ENCRYPTION	STATE
innodb_undo_001	Undo	N	active
innodb_undo_002	Undo	N	active
innodb_undo_003	Undo	N	active
innodb_undo_004	Undo	N	active
innodb_undo_005	Undo	N	active
innodb_undo_006	Undo	N	active
undo_3	Undo	N	active
# Create a new UNDO tablespace. Should be created as UNENCRYPTED.
CREATE UNDO TABLESPACE undo_4 ADD DATAFILE 'undo_4.ibu';
SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
NAME	SPACE_TYPE	ENCRYPTION	STATE
innodb_undo_001	Undo	N	active
innodb_undo_002	Undo	N	active
innodb_undo_003	Undo	N	active
innodb_undo_004	Undo	N	active
innodb_undo_005	Undo	N	active
innodb_undo_006	Undo	N	active
undo_3	Undo	N	active
undo_4	Undo	N	active
SET GLOBAL innodb_undo_log_encrypt=ON;
SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
Variable_name	Value
innodb_undo_log_encrypt	ON
SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
NAME	SPACE_TYPE	ENCRYPTION	STATE
innodb_undo_001	Undo	Y	active
innodb_undo_002	Undo	Y	active
innodb_undo_003	Undo	Y	active
innodb_undo_004	Undo	Y	active
innodb_undo_005	Undo	Y	active
innodb_undo_006	Undo	Y	active
undo_3	Undo	Y	active
undo_4	Undo	Y	active
###############################################################################
# With keyring plugin and innodb_undo_log_encrypt=OFF
###############################################################################
ALTER UNDO TABLESPACE undo_3 set INACTIVE;
SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
NAME	SPACE_TYPE	ENCRYPTION	STATE
innodb_undo_001	Undo	N	active
innodb_undo_002	Undo	N	active
innodb_undo_003	Undo	N	active
innodb_undo_004	Undo	N	active
innodb_undo_005	Undo	N	active
innodb_undo_006	Undo	N	active
undo_3	Undo	N	inactive
undo_4	Undo	N	active
DROP UNDO TABLESPACE undo_3;
ALTER UNDO TABLESPACE undo_4 set INACTIVE;
SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
NAME	SPACE_TYPE	ENCRYPTION	STATE
innodb_undo_001	Undo	N	active
innodb_undo_002	Undo	N	active
innodb_undo_003	Undo	N	active
innodb_undo_004	Undo	N	active
innodb_undo_005	Undo	N	active
innodb_undo_006	Undo	N	active
undo_4	Undo	N	inactive
DROP UNDO TABLESPACE undo_4;
SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
NAME	SPACE_TYPE	ENCRYPTION	STATE
innodb_undo_001	Undo	N	active
innodb_undo_002	Undo	N	active
innodb_undo_003	Undo	N	active
innodb_undo_004	Undo	N	active
innodb_undo_005	Undo	N	active
innodb_undo_006	Undo	N	active