Debian Codegraph @

mysql-test/suite/innodb/r/table_encrypt_fts.result

raw
1 #
2 # Bug#30787535 : FULLTEXT INDEX TABLES CREATED IN ENCRYPTED SCHEMA ARE NOT ENCRYPTED
3 #
4 #########
5 # SETUP #
6 #########
7
8 #########################################################################
9 # RESTART 1 : WITH KEYRING PLUGIN
10 #########################################################################
11 # Create a new 'unencrypted' table
12 CREATE TABLE t1 (id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
13 C1 TEXT(500),
14 C2 VARCHAR(200),
15 C3 VARCHAR(200)) ENCRYPTION='N' ENGINE=InnoDB;
16 set global innodb_buf_flush_list_now = 1;
17 # ---------------------------------------------------------------
18 # Test 1 : t1 un-encrypted, FTS tables should also be unencrypted
19 # ---------------------------------------------------------------
20 # Check that tablespace file is not encrypted
21 # Print result
22 table space is Unencrypted.
23 CREATE FULLTEXT INDEX idx ON t1(C1);
24 Warnings:
25 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
26 set global innodb_buf_flush_list_now = 1;
27 # Check that FTS tablespaces file is not encrypted
28 # Print result
29 table space is Unencrypted.
30 # ---------------------------------------------------------------
31 # Test 1 : t1 encrypted, FTS tables should also be unencrypted
32 # ---------------------------------------------------------------
33 ALTER TABLE t1 ENCRYPTION='Y';
34 # Check that tablespace file is encrypted now
35 # Print result
36 table space is Encrypted.
37 # Check that FTS tablespace file is encrypted now
38 # Print result
39 table space is Encrypted.
40 ###########
41 # CLEANUP #
42 ###########
43 DROP TABLE test.t1;
44 # Restarting server without keyring to restore server state
45 # restart: