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
127
128
129
|
# ==== Purpose ====
#
# This script intends to test that privilege checks, within the applier context,
# aren't impacted when DDL changes are performed on the slave.
#
# ==== Requirements ====
#
# R1. Adding extra columns, on the slave, to a replicated table MUST not impact
# column level privilege checking.
# R2. Removing columns, on the slave, from a replicated table MUST not impact
# column level privilege checking.
#
# ==== Implementation ====
#
# TC.1) Check column level privilege checking with an extra column on the slave
# -----------------------------------------------------------------------------
# 1) Set applier privilege checks.
# 2) Set `binlog_row_image` to `MINIMAL`.
# 3) Create a table on the master.
# 4) Add an extra column on the slave.
# 5) Make a DDL change on the master.
# 6) Check tables have the same data on master and slave.
#
# TC.2) Check column level privilege checking with a column short on the slave
# ----------------------------------------------------------------------------
# 1) Create a table on the master with two or more columns.
# 2) Remove the table last column on the slave.
# 3) Make a DDL change on the master.
# 4) Check tables have the same data on master and slave.
#
# ==== References ====
#
# WL#12966 Replication with privilege checks
#
# BUG#30343310 ASSERTION `BIT < MAP->N_BITS' POST SLAVE RESTART IF SLAVE HAS
# MORE COLUMNS
#
--echo #
--echo # TC.1) Check column level privilege checking with an extra column on the
--echo # slave
--echo #
--source include/have_binlog_format_row.inc
--echo #
--echo # 1) Set applier privilege checks.
--echo #
--let $rpl_privilege_checks_user = *:'u1'@'localhost'
--let $rpl_privilege_checks_user_additional_grants = INSERT,CREATE,DROP
--source include/master-slave.inc
--echo #
--echo # 2) Set `binlog_row_image` to `MINIMAL`.
--echo #
--let $global_binlog_row_image = `SELECT @@global.binlog_row_image`
--let $session_binlog_row_image = `SELECT @@session.binlog_row_image`
SET @@global.binlog_row_image = MINIMAL;
SET @@session.binlog_row_image = MINIMAL;
--echo #
--echo # 3) Create a table on the master.
--echo #
--connection master
CREATE TABLE test.t1 (a INT);
--source include/sync_slave_sql_with_master.inc
--echo #
--echo # 4) Add an extra column on the slave.
--echo #
ALTER TABLE test.t1 ADD COLUMN b INT;
--source include/stop_slave.inc
--source include/start_slave.inc
--echo #
--echo # 5) Make a DDL change on the master.
--echo #
--connection master
INSERT INTO test.t1 VALUES (1);
--source include/sync_slave_sql_with_master.inc
--echo #
--echo # 6) Check tables have the same data on master and slave.
--echo #
--let $diff_tables = master:t1,slave:t1
--let $mask_column_list = b
--source include/diff_tables.inc
--echo #
--echo # TC.2) Check column level privilege checking with a column short on the
--echo # slave
--echo #
--echo #
--echo # 1) Create a table on the master with two or more columns.
--echo #
--connection master
CREATE TABLE test.t2 (a INT, b INT, c VARCHAR(50));
--source include/sync_slave_sql_with_master.inc
--echo #
--echo # 2) Remove the table last column on the slave.
--echo #
ALTER TABLE test.t2 DROP COLUMN c;
--source include/stop_slave.inc
--source include/start_slave.inc
--echo #
--echo # 3) Make a DDL change on the master.
--echo #
--connection master
INSERT INTO test.t2 VALUES (1,1,"a string of characters");
--source include/sync_slave_sql_with_master.inc
--echo #
--echo # 4) Check tables have the same data on master and slave.
--echo #
--let $diff_tables = master:t2,slave:t2
--let $mask_column_list = c
--source include/diff_tables.inc
# Clean up
--connection master
--replace_result $global_binlog_row_image GLOBAL_BINLOG_ROW_IMAGE
--eval SET @@global.binlog_row_image = $global_binlog_row_image
--replace_result $session_binlog_row_image SESSION_BINLOG_ROW_IMAGE
--eval SET @@session.binlog_row_image = $session_binlog_row_image
DROP TABLE t1;
DROP TABLE t2;
--source include/rpl_end.inc
|
