Debian Codegraph @

mysql-test/suite/component_keyring_file/r/mysqldump.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 # Pre-define user u1, which is used in different tests below.
8 CREATE USER u1@localhost;
9 GRANT ALL ON db1.* TO u1@localhost;
10 GRANT CREATE TABLESPACE, PROCESS, SYSTEM_VARIABLES_ADMIN ON *.* TO u1@localhost;
11 # This test run output (.sql) of mysqldump from 5.7, 8.0.12 and 8.0.13
12 # in 8.0.15.
13 #
14 # The .sql files contain notes with tag wl12261 describing the
15 # modifications done to .sql to make it run on MySQL 8.0.15.
16 # It basically does two things a) removes ENCRYPTION=y for CVS and
17 # MEMORY engines. b) Adds a explicit ENCRYPTION='y' for tables
18 # using encryped general tablespace.
19 #
20 # The behavior of executing .sql with following variables would be
21 # same as the test behavior seen by encryption.* test results.
22 #
23 # - Setting table_encryption_privilege_check to true/false.
24 # - Setting default_table_encryption to true/false.
25 # - With and without user holding TABLE_ENCRYPTION_ADMIN privilege.
26 #
27 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
28 CREATE TABLESPACE ts2 ADD DATAFILE 'ts2.ibd';
29 CREATE TABLESPACE ts3 ADD DATAFILE 'ts3.ibd';
30 SHOW CREATE DATABASE db1;
31 Database Create Database
32 db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET latin1 */ /*!80016 DEFAULT ENCRYPTION='N' */
33 SHOW CREATE TABLE db1.i1;
34 Table Create Table
35 i1 CREATE TABLE `i1` (
36 `f1` int DEFAULT NULL
37 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
38 SHOW CREATE TABLE db1.i2;
39 Table Create Table
40 i2 CREATE TABLE `i2` (
41 `f1` int DEFAULT NULL
42 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ENCRYPTION='y'
43 SHOW CREATE TABLE db1.i3;
44 Table Create Table
45 i3 CREATE TABLE `i3` (
46 `f1` int DEFAULT NULL
47 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
48 SHOW CREATE TABLE db1.i4;
49 Table Create Table
50 i4 CREATE TABLE `i4` (
51 `f1` int DEFAULT NULL
52 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
53 SHOW CREATE TABLE db1.i_ts1;
54 Table Create Table
55 i_ts1 CREATE TABLE `i_ts1` (
56 `f1` int DEFAULT NULL
57 ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
58 SHOW CREATE TABLE db1.i_ts2;
59 Table Create Table
60 i_ts2 CREATE TABLE `i_ts2` (
61 `f1` int DEFAULT NULL
62 ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
63 SHOW CREATE TABLE db1.i_ts3;
64 Table Create Table
65 i_ts3 CREATE TABLE `i_ts3` (
66 `f1` int DEFAULT NULL
67 ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
68 SHOW CREATE TABLE db1.i_part1;
69 Table Create Table
70 i_part1 CREATE TABLE `i_part1` (
71 `id` int DEFAULT NULL,
72 `name` varchar(50) DEFAULT NULL
73 ) /*!50100 TABLESPACE `innodb_file_per_table` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
74 /*!50100 PARTITION BY RANGE (`id`)
75 (PARTITION p0 VALUES LESS THAN (10) ENGINE = InnoDB,
76 PARTITION p1 VALUES LESS THAN (20) ENGINE = InnoDB,
77 PARTITION p2 VALUES LESS THAN (30) ENGINE = InnoDB) */
78 SHOW CREATE TABLE db1.i_part2;
79 Table Create Table
80 i_part2 CREATE TABLE `i_part2` (
81 `id` int DEFAULT NULL,
82 `name` varchar(50) DEFAULT NULL
83 ) /*!50100 TABLESPACE `innodb_file_per_table` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 ENCRYPTION='y'
84 /*!50100 PARTITION BY RANGE (`id`)
85 (PARTITION p0 VALUES LESS THAN (10) ENGINE = InnoDB,
86 PARTITION p1 VALUES LESS THAN (20) ENGINE = InnoDB,
87 PARTITION p2 VALUES LESS THAN (30) ENGINE = InnoDB) */
88 SHOW CREATE TABLE db1.i_part3;
89 Table Create Table
90 i_part3 CREATE TABLE `i_part3` (
91 `id` int DEFAULT NULL,
92 `name` varchar(50) DEFAULT NULL
93 ) /*!50100 TABLESPACE `innodb_file_per_table` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
94 /*!50100 PARTITION BY RANGE (`id`)
95 (PARTITION p0 VALUES LESS THAN (10) ENGINE = InnoDB,
96 PARTITION p1 VALUES LESS THAN (20) ENGINE = InnoDB,
97 PARTITION p2 VALUES LESS THAN (30) ENGINE = InnoDB) */
98 SHOW CREATE TABLE db1.c1;
99 Table Create Table
100 c1 CREATE TABLE `c1` (
101 `f1` int NOT NULL
102 ) ENGINE=CSV DEFAULT CHARSET=latin1
103 SHOW CREATE TABLE db1.c2;
104 Table Create Table
105 c2 CREATE TABLE `c2` (
106 `f1` int NOT NULL
107 ) ENGINE=CSV DEFAULT CHARSET=latin1
108 SHOW CREATE TABLE db1.c3;
109 Table Create Table
110 c3 CREATE TABLE `c3` (
111 `f1` int NOT NULL
112 ) ENGINE=CSV DEFAULT CHARSET=latin1
113 SHOW CREATE TABLE db1.h1;
114 Table Create Table
115 h1 CREATE TABLE `h1` (
116 `f1` int DEFAULT NULL
117 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
118 SHOW CREATE TABLE db1.h2;
119 Table Create Table
120 h2 CREATE TABLE `h2` (
121 `f1` int DEFAULT NULL
122 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
123 SHOW CREATE TABLE db1.h3;
124 Table Create Table
125 h3 CREATE TABLE `h3` (
126 `f1` int DEFAULT NULL
127 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
128 DROP DATABASE db1;
129 DROP TABLESPACE ts1;
130 DROP TABLESPACE ts2;
131 DROP TABLESPACE ts3;
132 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
133 CREATE TABLESPACE ts2 ADD DATAFILE 'ts2.ibd';
134 CREATE TABLESPACE ts3 ADD DATAFILE 'ts3.ibd';
135 SHOW CREATE DATABASE db1;
136 Database Create Database
137 db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
138 SHOW CREATE TABLE db1.i1;
139 Table Create Table
140 i1 CREATE TABLE `i1` (
141 `f1` int DEFAULT NULL
142 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
143 SHOW CREATE TABLE db1.i2;
144 Table Create Table
145 i2 CREATE TABLE `i2` (
146 `f1` int DEFAULT NULL
147 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='y'
148 SHOW CREATE TABLE db1.i3;
149 Table Create Table
150 i3 CREATE TABLE `i3` (
151 `f1` int DEFAULT NULL
152 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
153 SHOW CREATE TABLE db1.i4;
154 Table Create Table
155 i4 CREATE TABLE `i4` (
156 `f1` int DEFAULT NULL
157 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
158 SHOW CREATE TABLE db1.i_ts1;
159 Table Create Table
160 i_ts1 CREATE TABLE `i_ts1` (
161 `f1` int DEFAULT NULL
162 ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
163 SHOW CREATE TABLE db1.i_ts2;
164 Table Create Table
165 i_ts2 CREATE TABLE `i_ts2` (
166 `f1` int DEFAULT NULL
167 ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
168 SHOW CREATE TABLE db1.i_ts3;
169 Table Create Table
170 i_ts3 CREATE TABLE `i_ts3` (
171 `f1` int DEFAULT NULL
172 ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
173 SHOW CREATE TABLE db1.i_part1;
174 Table Create Table
175 i_part1 CREATE TABLE `i_part1` (
176 `id` int DEFAULT NULL,
177 `name` varchar(50) DEFAULT NULL
178 ) /*!50100 TABLESPACE `innodb_file_per_table` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
179 /*!50100 PARTITION BY RANGE (`id`)
180 (PARTITION p0 VALUES LESS THAN (10) ENGINE = InnoDB,
181 PARTITION p1 VALUES LESS THAN (20) ENGINE = InnoDB,
182 PARTITION p2 VALUES LESS THAN (30) ENGINE = InnoDB) */
183 SHOW CREATE TABLE db1.i_part2;
184 Table Create Table
185 i_part2 CREATE TABLE `i_part2` (
186 `id` int DEFAULT NULL,
187 `name` varchar(50) DEFAULT NULL
188 ) /*!50100 TABLESPACE `innodb_file_per_table` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='y'
189 /*!50100 PARTITION BY RANGE (`id`)
190 (PARTITION p0 VALUES LESS THAN (10) ENGINE = InnoDB,
191 PARTITION p1 VALUES LESS THAN (20) ENGINE = InnoDB,
192 PARTITION p2 VALUES LESS THAN (30) ENGINE = InnoDB) */
193 SHOW CREATE TABLE db1.i_part3;
194 Table Create Table
195 i_part3 CREATE TABLE `i_part3` (
196 `id` int DEFAULT NULL,
197 `name` varchar(50) DEFAULT NULL
198 ) /*!50100 TABLESPACE `innodb_file_per_table` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
199 /*!50100 PARTITION BY RANGE (`id`)
200 (PARTITION p0 VALUES LESS THAN (10) ENGINE = InnoDB,
201 PARTITION p1 VALUES LESS THAN (20) ENGINE = InnoDB,
202 PARTITION p2 VALUES LESS THAN (30) ENGINE = InnoDB) */
203 SHOW CREATE TABLE db1.c1;
204 Table Create Table
205 c1 CREATE TABLE `c1` (
206 `f1` int NOT NULL
207 ) ENGINE=CSV DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
208 SHOW CREATE TABLE db1.c2;
209 Table Create Table
210 c2 CREATE TABLE `c2` (
211 `f1` int NOT NULL
212 ) ENGINE=CSV DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
213 SHOW CREATE TABLE db1.c3;
214 Table Create Table
215 c3 CREATE TABLE `c3` (
216 `f1` int NOT NULL
217 ) ENGINE=CSV DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
218 SHOW CREATE TABLE db1.h1;
219 Table Create Table
220 h1 CREATE TABLE `h1` (
221 `f1` int DEFAULT NULL
222 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
223 SHOW CREATE TABLE db1.h2;
224 Table Create Table
225 h2 CREATE TABLE `h2` (
226 `f1` int DEFAULT NULL
227 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
228 SHOW CREATE TABLE db1.h3;
229 Table Create Table
230 h3 CREATE TABLE `h3` (
231 `f1` int DEFAULT NULL
232 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
233 DROP DATABASE db1;
234 DROP TABLESPACE ts1;
235 DROP TABLESPACE ts2;
236 DROP TABLESPACE ts3;
237 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
238 CREATE TABLESPACE ts2 ADD DATAFILE 'ts2.ibd' ENCRYPTION='n';
239 CREATE TABLESPACE ts3 ADD DATAFILE 'ts3.ibd' ENCRYPTION='y';
240 CREATE TABLESPACE ts4 ADD DATAFILE 'ts4.ibd';
241 SHOW CREATE DATABASE db1;
242 Database Create Database
243 db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
244 SHOW CREATE TABLE db1.i1;
245 Table Create Table
246 i1 CREATE TABLE `i1` (
247 `f1` int DEFAULT NULL
248 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
249 SHOW CREATE TABLE db1.i2;
250 Table Create Table
251 i2 CREATE TABLE `i2` (
252 `f1` int DEFAULT NULL
253 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='y'
254 SHOW CREATE TABLE db1.i3;
255 Table Create Table
256 i3 CREATE TABLE `i3` (
257 `f1` int DEFAULT NULL
258 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
259 SHOW CREATE TABLE db1.i_ts1;
260 Table Create Table
261 i_ts1 CREATE TABLE `i_ts1` (
262 `f1` int DEFAULT NULL
263 ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
264 SHOW CREATE TABLE db1.i_ts2;
265 Table Create Table
266 i_ts2 CREATE TABLE `i_ts2` (
267 `f1` int DEFAULT NULL
268 ) /*!50100 TABLESPACE `ts2` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
269 SHOW CREATE TABLE db1.i_ts3;
270 Table Create Table
271 i_ts3 CREATE TABLE `i_ts3` (
272 `f1` int DEFAULT NULL
273 ) /*!50100 TABLESPACE `ts3` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!80016 ENCRYPTION='y' */
274 SHOW CREATE TABLE db1.i_ts4;
275 Table Create Table
276 i_ts4 CREATE TABLE `i_ts4` (
277 `f1` int DEFAULT NULL
278 ) /*!50100 TABLESPACE `ts4` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
279 SHOW CREATE TABLE db1.i_part1;
280 Table Create Table
281 i_part1 CREATE TABLE `i_part1` (
282 `id` int DEFAULT NULL,
283 `name` varchar(50) DEFAULT NULL
284 ) /*!50100 TABLESPACE `innodb_file_per_table` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
285 /*!50100 PARTITION BY RANGE (`id`)
286 (PARTITION p0 VALUES LESS THAN (10) ENGINE = InnoDB,
287 PARTITION p1 VALUES LESS THAN (20) ENGINE = InnoDB,
288 PARTITION p2 VALUES LESS THAN (30) ENGINE = InnoDB) */
289 SHOW CREATE TABLE db1.i_part2;
290 Table Create Table
291 i_part2 CREATE TABLE `i_part2` (
292 `id` int DEFAULT NULL,
293 `name` varchar(50) DEFAULT NULL
294 ) /*!50100 TABLESPACE `innodb_file_per_table` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='y'
295 /*!50100 PARTITION BY RANGE (`id`)
296 (PARTITION p0 VALUES LESS THAN (10) ENGINE = InnoDB,
297 PARTITION p1 VALUES LESS THAN (20) ENGINE = InnoDB,
298 PARTITION p2 VALUES LESS THAN (30) ENGINE = InnoDB) */
299 SHOW CREATE TABLE db1.i_part3;
300 Table Create Table
301 i_part3 CREATE TABLE `i_part3` (
302 `id` int DEFAULT NULL,
303 `name` varchar(50) DEFAULT NULL
304 ) /*!50100 TABLESPACE `innodb_file_per_table` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
305 /*!50100 PARTITION BY RANGE (`id`)
306 (PARTITION p0 VALUES LESS THAN (10) ENGINE = InnoDB,
307 PARTITION p1 VALUES LESS THAN (20) ENGINE = InnoDB,
308 PARTITION p2 VALUES LESS THAN (30) ENGINE = InnoDB) */
309 SHOW CREATE TABLE db1.c1;
310 Table Create Table
311 c1 CREATE TABLE `c1` (
312 `f1` int NOT NULL
313 ) ENGINE=CSV DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
314 SHOW CREATE TABLE db1.c2;
315 Table Create Table
316 c2 CREATE TABLE `c2` (
317 `f1` int NOT NULL
318 ) ENGINE=CSV DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
319 SHOW CREATE TABLE db1.c3;
320 Table Create Table
321 c3 CREATE TABLE `c3` (
322 `f1` int NOT NULL
323 ) ENGINE=CSV DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
324 SHOW CREATE TABLE db1.h1;
325 Table Create Table
326 h1 CREATE TABLE `h1` (
327 `f1` int DEFAULT NULL
328 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
329 SHOW CREATE TABLE db1.h2;
330 Table Create Table
331 h2 CREATE TABLE `h2` (
332 `f1` int DEFAULT NULL
333 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
334 SHOW CREATE TABLE db1.h3;
335 Table Create Table
336 h3 CREATE TABLE `h3` (
337 `f1` int DEFAULT NULL
338 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
339 DROP DATABASE db1;
340 DROP TABLESPACE ts1;
341 DROP TABLESPACE ts2;
342 DROP TABLESPACE ts3;
343 DROP TABLESPACE ts4;
344 # Cleanup
345 DROP USER u1@localhost;
346 # ----------------------------------------------------------------------
347 # Teardown
348 # Removing manifest file for current MySQL server instance
349 # Removing local keyring file for keyring component: component_keyring_file
350 # Removing local configuration file for keyring component: component_keyring_file
351 # Restarting server without the manifest file
352 # ----------------------------------------------------------------------