Debian Codegraph @

mysql-test/suite/encryption/t/mysqldump.test

raw
1 --source include/have_debug.inc
2 --source include/no_valgrind_without_big.inc
3 --source include/have_case_sensitive_file_system.inc
4
5 --copy_file $MYSQLTEST_VARDIR/std_data/wl12261_dump.zip $MYSQL_TMP_DIR/wl12261_dump.zip
6 --file_exists $MYSQL_TMP_DIR/wl12261_dump.zip
7 --exec unzip -qo $MYSQL_TMP_DIR/wl12261_dump.zip -d $MYSQL_TMP_DIR
8
9 --echo # Pre-define user u1, which is used in different tests below.
10 CREATE USER u1@localhost;
11 GRANT ALL ON db1.* TO u1@localhost;
12 GRANT CREATE TABLESPACE, PROCESS, SYSTEM_VARIABLES_ADMIN ON *.* TO u1@localhost;
13 connect (con1, localhost, u1);
14
15 --echo # This test run output (.sql) of mysqldump from 5.7, 8.0.12 and 8.0.13
16 --echo # in 8.0.15.
17 --echo #
18 --echo # The .sql files contain notes with tag wl12261 describing the
19 --echo # modifications done to .sql to make it run on MySQL 8.0.15.
20 --echo # It basically does two things a) removes ENCRYPTION=y for CVS and
21 --echo # MEMORY engines. b) Adds a explicit ENCRYPTION='y' for tables
22 --echo # using encryped general tablespace.
23 --echo #
24 --echo # The behavior of executing .sql with following variables would be
25 --echo # same as the test behavior seen by encryption.* test results.
26 --echo #
27 --echo # - Setting table_encryption_privilege_check to true/false.
28 --echo # - Setting default_table_encryption to true/false.
29 --echo # - With and without user holding TABLE_ENCRYPTION_ADMIN privilege.
30 --echo #
31
32 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
33 CREATE TABLESPACE ts2 ADD DATAFILE 'ts2.ibd';
34 CREATE TABLESPACE ts3 ADD DATAFILE 'ts3.ibd';
35
36 --exec $MYSQL test < $MYSQL_TMP_DIR/wl12261_5_7_25.sql
37 SHOW CREATE DATABASE db1;
38 SHOW CREATE TABLE db1.i1;
39 SHOW CREATE TABLE db1.i2;
40 SHOW CREATE TABLE db1.i3;
41 SHOW CREATE TABLE db1.i4;
42 SHOW CREATE TABLE db1.i_ts1;
43 SHOW CREATE TABLE db1.i_ts2;
44 SHOW CREATE TABLE db1.i_ts3;
45 SHOW CREATE TABLE db1.i_part1;
46 SHOW CREATE TABLE db1.i_part2;
47 SHOW CREATE TABLE db1.i_part3;
48 SHOW CREATE TABLE db1.c1;
49 SHOW CREATE TABLE db1.c2;
50 SHOW CREATE TABLE db1.c3;
51 SHOW CREATE TABLE db1.h1;
52 SHOW CREATE TABLE db1.h2;
53 SHOW CREATE TABLE db1.h3;
54 DROP DATABASE db1;
55 DROP TABLESPACE ts1;
56 DROP TABLESPACE ts2;
57 DROP TABLESPACE ts3;
58
59
60 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
61 CREATE TABLESPACE ts2 ADD DATAFILE 'ts2.ibd';
62 CREATE TABLESPACE ts3 ADD DATAFILE 'ts3.ibd';
63
64 --exec $MYSQL test < $MYSQL_TMP_DIR/wl12261_8_0_12.sql
65 SHOW CREATE DATABASE db1;
66 SHOW CREATE TABLE db1.i1;
67 SHOW CREATE TABLE db1.i2;
68 SHOW CREATE TABLE db1.i3;
69 SHOW CREATE TABLE db1.i4;
70 SHOW CREATE TABLE db1.i_ts1;
71 SHOW CREATE TABLE db1.i_ts2;
72 SHOW CREATE TABLE db1.i_ts3;
73 SHOW CREATE TABLE db1.i_part1;
74 SHOW CREATE TABLE db1.i_part2;
75 SHOW CREATE TABLE db1.i_part3;
76 SHOW CREATE TABLE db1.c1;
77 SHOW CREATE TABLE db1.c2;
78 SHOW CREATE TABLE db1.c3;
79 SHOW CREATE TABLE db1.h1;
80 SHOW CREATE TABLE db1.h2;
81 SHOW CREATE TABLE db1.h3;
82 DROP DATABASE db1;
83 DROP TABLESPACE ts1;
84 DROP TABLESPACE ts2;
85 DROP TABLESPACE ts3;
86
87
88 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
89 CREATE TABLESPACE ts2 ADD DATAFILE 'ts2.ibd' ENCRYPTION='n';
90 CREATE TABLESPACE ts3 ADD DATAFILE 'ts3.ibd' ENCRYPTION='y';
91 CREATE TABLESPACE ts4 ADD DATAFILE 'ts4.ibd';
92
93 --exec $MYSQL test < $MYSQL_TMP_DIR/wl12261_8_0_13.sql
94 SHOW CREATE DATABASE db1;
95 SHOW CREATE TABLE db1.i1;
96 SHOW CREATE TABLE db1.i2;
97 SHOW CREATE TABLE db1.i3;
98 SHOW CREATE TABLE db1.i_ts1;
99 SHOW CREATE TABLE db1.i_ts2;
100 SHOW CREATE TABLE db1.i_ts3;
101 SHOW CREATE TABLE db1.i_ts4;
102 SHOW CREATE TABLE db1.i_part1;
103 SHOW CREATE TABLE db1.i_part2;
104 SHOW CREATE TABLE db1.i_part3;
105 SHOW CREATE TABLE db1.c1;
106 SHOW CREATE TABLE db1.c2;
107 SHOW CREATE TABLE db1.c3;
108 SHOW CREATE TABLE db1.h1;
109 SHOW CREATE TABLE db1.h2;
110 SHOW CREATE TABLE db1.h3;
111 DROP DATABASE db1;
112 DROP TABLESPACE ts1;
113 DROP TABLESPACE ts2;
114 DROP TABLESPACE ts3;
115 DROP TABLESPACE ts4;
116
117 --echo # Cleanup
118 disconnect con1;
119 connection default;
120
121 DROP USER u1@localhost;
122
123 --remove_file $MYSQL_TMP_DIR/wl12261_dump.zip
124 --remove_file $MYSQL_TMP_DIR/wl12261_5_7_25.sql
125 --remove_file $MYSQL_TMP_DIR/wl12261_8_0_12.sql
126 --remove_file $MYSQL_TMP_DIR/wl12261_8_0_13.sql