Debian Codegraph @

mysql-test/suite/component_keyring_file/r/tablespace_encrypt_8.result

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 # Creating local configuration file for keyring component: component_keyring_file
4 # Creating manifest file for current MySQL server instance
5 # Re-starting mysql server with manifest file
6 # ----------------------------------------------------------------------
7 #########################################################################
8 # RESTART 1 : WITH KEYRING
9 #########################################################################
10 SET SESSION debug= '+d,ddl_btree_build_insert_return_interrupt';
11
12 #########
13 # SETUP #
14 #########
15 CREATE PROCEDURE populate_t1()
16 BEGIN
17 DECLARE i int DEFAULT 1;
18 START TRANSACTION;
19 WHILE (i <= 10000) DO
20 INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
21 SET i = i + 1;
22 END WHILE;
23 COMMIT;
24 END|
25 CREATE TABLE t1(class INT, id INT, title VARCHAR(100)) encryption='N';
26 CREATE TABLESPACE encrypt_ts ADD DATAFILE 'encrypt_ts.ibd' encryption='N';
27 ALTER TABLE t1 TABLESPACE=encrypt_ts, ALGORITHM=INPLACE;
28 ERROR 70100: Query execution was interrupted
29 ALTER TABLESPACE encrypt_ts ENCRYPTION='Y';
30 #########################################################################
31 # RESTART 2 : WITH KEYRING PLUGIN
32 #########################################################################
33 ALTER TABLESPACE encrypt_ts ENCRYPTION='N';
34 ###########
35 # Cleanup #
36 ###########
37 DROP TABLE t1;
38 DROP TABLESPACE encrypt_ts;
39 DROP PROCEDURE populate_t1;
40 # ----------------------------------------------------------------------
41 # Teardown
42 # Removing manifest file for current MySQL server instance
43 # Removing local keyring file for keyring component: component_keyring_file
44 # Removing local configuration file for keyring component: component_keyring_file
45 # Restarting server without the manifest file
46 # ----------------------------------------------------------------------