Debian Codegraph @

mysql-test/suite/innodb/t/table_encrypt_4.test

raw
1 # InnoDB transparent tablespace data encryption
2 # This test case will test export/import encrypted tablespace.
3
4 --source include/no_valgrind_without_big.inc
5 --source include/have_debug.inc
6
7 --disable_query_log
8 call mtr.add_suppression("Trying to import a encrypted tablespace, but could not get encryption information from .cfp file");
9 call mtr.add_suppression("Operating system error number .* in a file operation");
10 call mtr.add_suppression("The error means the system cannot find the path specified.");
11 call mtr.add_suppression("'delete' returned OS error 7");
12 call mtr.add_suppression("Trying to import a tablespace, but could not open the tablespace file");
13 call mtr.add_suppression("Table is not in an encrypted tablespace, but the data file intended for import is an encrypted tablespace");
14 --enable_query_log
15
16 --disable_warnings
17 DROP TABLE IF EXISTS t1;
18 --enable_warnings
19
20 let $innodb_file_per_table = `SELECT @@innodb_file_per_table`;
21
22 SET GLOBAL innodb_file_per_table = 1;
23 SELECT @@innodb_file_per_table;
24
25 --echo # Create a table with encryption
26 CREATE TABLE t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
27
28 SHOW CREATE TABLE t1;
29 INSERT INTO t1 VALUES(0, "aaaaa");
30 INSERT INTO t1 VALUES(1, "bbbbb");
31 INSERT INTO t1 VALUES(2, "ccccc");
32 INSERT INTO t1 VALUES(3, "ddddd");
33 INSERT INTO t1 VALUES(4, "eeeee");
34 INSERT INTO t1 VALUES(5, "fffff");
35 INSERT INTO t1 VALUES(6, "ggggg");
36 INSERT INTO t1 VALUES(7, "hhhhh");
37 INSERT INTO t1 VALUES(8, "iiiii");
38 INSERT INTO t1 VALUES(9, "jjjjj");
39 INSERT INTO t1 select * from t1;
40 INSERT INTO t1 select * from t1;
41 INSERT INTO t1 select * from t1;
42 INSERT INTO t1 select * from t1;
43 INSERT INTO t1 select * from t1;
44 INSERT INTO t1 select * from t1;
45
46 SELECT * FROM t1 LIMIT 10;
47
48 --echo # Test export/import encrypted tablespace.
49 let $MYSQLD_DATADIR = `SELECT @@datadir`;
50
51 if(!$source_db) {
52 let $source_db = test;
53 }
54
55 if(!$dest_db) {
56 let $dest_db = test;
57 }
58
59 eval FLUSH TABLES $source_db.t1 FOR EXPORT;
60
61 --copy_file $MYSQLD_DATADIR/$source_db/t1.cfg $MYSQLD_DATADIR/t1.cfg_back
62 --copy_file $MYSQLD_DATADIR/$source_db/t1.cfp $MYSQLD_DATADIR/t1.cfp_back
63 --copy_file $MYSQLD_DATADIR/$source_db/t1.ibd $MYSQLD_DATADIR/t1.ibd_back
64
65 UNLOCK TABLES;
66
67 if($source_db != $dest_db) {
68 eval USE $dest_db;
69 let $create1 = query_get_value(SHOW CREATE TABLE $source_db.t1, Create Table, 1);
70 eval $create1;
71 }
72
73 eval ALTER TABLE $dest_db.t1 DISCARD TABLESPACE;
74
75 --copy_file $MYSQLD_DATADIR/t1.cfg_back $MYSQLD_DATADIR/$dest_db/t1.cfg
76 --copy_file $MYSQLD_DATADIR/t1.cfp_back $MYSQLD_DATADIR/$dest_db/t1.cfp
77 --copy_file $MYSQLD_DATADIR/t1.ibd_back $MYSQLD_DATADIR/$dest_db/t1.ibd
78
79 eval ALTER TABLE $dest_db.t1 IMPORT TABLESPACE;
80
81 eval CHECK TABLE $dest_db.t1;
82 eval SHOW CREATE TABLE $dest_db.t1;
83 eval SELECT * FROM $dest_db.t1 LIMIT 10;
84
85 if($source_db != $dest_db) {
86 eval DROP TABLE $dest_db.t1;
87 }
88
89 --let $restart_parameters= restart:
90 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH
91 --replace_regex /\.dll/.so/
92 --source include/restart_mysqld.inc
93
94 eval SELECT * FROM $dest_db.t1 LIMIT 10;
95
96 eval ALTER TABLE $dest_db.t1 DISCARD TABLESPACE;
97
98 --copy_file $MYSQLD_DATADIR/t1.cfg_back $MYSQLD_DATADIR/$dest_db/t1.cfg
99 --copy_file $MYSQLD_DATADIR/t1.cfp_back $MYSQLD_DATADIR/$dest_db/t1.cfp
100 --copy_file $MYSQLD_DATADIR/t1.ibd_back $MYSQLD_DATADIR/$dest_db/t1.ibd
101
102 --echo # Try import in another session.
103 connect (con1,localhost,root);
104 --disable_warnings
105 eval ALTER TABLE $dest_db.t1 IMPORT TABLESPACE;
106 --enable_warnings
107 disconnect con1;
108
109 connection default;
110
111 eval SELECT * FROM $dest_db.t1 LIMIT 10;
112
113 # Try negative case
114 eval ALTER TABLE $dest_db.t1 DISCARD TABLESPACE;
115
116 --echo # Import without .cfg file is posible
117 --echo # copying .cfp and .ibd file
118 --copy_file $MYSQLD_DATADIR/t1.cfp_back $MYSQLD_DATADIR/$dest_db/t1.cfp
119 --copy_file $MYSQLD_DATADIR/t1.ibd_back $MYSQLD_DATADIR/$dest_db/t1.ibd
120 eval ALTER TABLE $dest_db.t1 IMPORT TABLESPACE;
121 eval SELECT * FROM $dest_db.t1 LIMIT 10;
122 ALTER INSTANCE ROTATE INNODB MASTER KEY;
123 eval SELECT * FROM $dest_db.t1 LIMIT 10;
124 eval ALTER TABLE $dest_db.t1 DISCARD TABLESPACE;
125
126
127 --echo # Import without .cfp file
128 --echo # copying .cfg and .ibd file
129 --copy_file $MYSQLD_DATADIR/t1.ibd_back $MYSQLD_DATADIR/$dest_db/t1.ibd
130 --copy_file $MYSQLD_DATADIR/t1.cfg_back $MYSQLD_DATADIR/$dest_db/t1.cfg
131 --error 1808
132 eval ALTER TABLE $dest_db.t1 IMPORT TABLESPACE;
133 ALTER INSTANCE ROTATE INNODB MASTER KEY;
134 --remove_file $MYSQLD_DATADIR/$dest_db/t1.ibd
135 --remove_file $MYSQLD_DATADIR/$dest_db/t1.cfg
136
137 --echo # Import without .idb file
138 --echo # copying .cfp and .cfg file
139 --copy_file $MYSQLD_DATADIR/t1.cfg_back $MYSQLD_DATADIR/$dest_db/t1.cfg
140 --copy_file $MYSQLD_DATADIR/t1.cfp_back $MYSQLD_DATADIR/$dest_db/t1.cfp
141 --error 1815
142 eval ALTER TABLE $dest_db.t1 IMPORT TABLESPACE;
143 ALTER INSTANCE ROTATE INNODB MASTER KEY;
144 --remove_file $MYSQLD_DATADIR/$dest_db/t1.cfg
145 --remove_file $MYSQLD_DATADIR/$dest_db/t1.cfp
146
147 --echo # Schema mismatch dest table without encryption - fix result
148 DROP TABLE t1;
149 eval CREATE TABLE $dest_db.t1(c1 INT, c2 char(20)) ENGINE = InnoDB;
150 eval ALTER TABLE $dest_db.t1 DISCARD TABLESPACE;
151 --copy_file $MYSQLD_DATADIR/t1.cfp_back $MYSQLD_DATADIR/$dest_db/t1.cfp
152 --copy_file $MYSQLD_DATADIR/t1.ibd_back $MYSQLD_DATADIR/$dest_db/t1.ibd
153 --copy_file $MYSQLD_DATADIR/t1.cfg_back $MYSQLD_DATADIR/$dest_db/t1.cfg
154 --error 1808
155 eval ALTER TABLE $dest_db.t1 IMPORT TABLESPACE;
156
157 --echo # Import got expected error.
158 DROP TABLE t1;
159 --remove_file $MYSQLD_DATADIR/$dest_db/t1.cfg
160 --remove_file $MYSQLD_DATADIR/$dest_db/t1.cfp
161 --remove_file $MYSQLD_DATADIR/$dest_db/t1.ibd
162 eval CREATE TABLE $dest_db.t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
163 eval ALTER TABLE $dest_db.t1 DISCARD TABLESPACE;
164 --copy_file $MYSQLD_DATADIR/t1.cfp_back $MYSQLD_DATADIR/$dest_db/t1.cfp
165 --copy_file $MYSQLD_DATADIR/t1.ibd_back $MYSQLD_DATADIR/$dest_db/t1.ibd
166 --copy_file $MYSQLD_DATADIR/t1.cfg_back $MYSQLD_DATADIR/$dest_db/t1.cfg
167 SET SESSION DEBUG="+d, fsp_header_rotate_encryption_failure";
168 --error ER_GET_ERRNO
169 eval ALTER TABLE $dest_db.t1 IMPORT TABLESPACE;
170
171 # Cleanup
172 --disable_query_log
173 eval DROP TABLE IF EXISTS $dest_db.t1;
174 eval DROP TABLE IF EXISTS $source_db.t1;
175 --enable_query_log
176 --remove_files_wildcard $MYSQLD_DATADIR/$dest_db/ t1.*
177 --remove_file $MYSQLD_DATADIR/t1.cfg_back
178 --remove_file $MYSQLD_DATADIR/t1.cfp_back
179 --remove_file $MYSQLD_DATADIR/t1.ibd_back