Debian Codegraph @

mysql-test/suite/encryption/r/mysqldump.result

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