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