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
|
--echo #
--echo # Bug#30072179: USING INVISIBLE INDEX WHEN SLAVE APPLY EVENT
--echo #
#
# The variable Replica_rows_last_search_algorithm_used forms the basis for this
# test, and it is only available in debug builds.
#
--source include/have_debug.inc
--source include/master-slave.inc
--echo [Connection Master]
--connection master
SET sql_log_bin = OFF;
CREATE TABLE t1 ( a INT NOT NULL, b INT NOT NULL, C INT, PRIMARY KEY (a));
SET sql_log_bin = ON;
--echo [Connection Slave]
--connection slave
CREATE TABLE t1 (
a INT NOT NULL,
b INT NOT NULL,
c INT,
PRIMARY KEY (b),
UNIQUE KEY(a) INVISIBLE
);
--echo [Connection Master]
--connection master
INSERT INTO t1 VALUES (1, 1, 1), (2, 2, 2), (3, 3, 3);
UPDATE t1 SET c = 100 WHERE a = 1;
--source include/sync_slave_sql_with_master.inc
--echo [Connection Slave]
--connection slave
--echo # Should not have used the a index to syncronize the row.
SELECT 1 AS not_using_index FROM performance_schema.global_status
WHERE variable_name = 'Replica_rows_last_search_algorithm_used'
AND variable_value <> 'INDEX_SCAN';
--echo # Make sure it indeed synchronized. This _will_ use the index.
SELECT * FROM t1;
--echo [Connection Master]
--connection master
DROP TABLE t1;
--source include/sync_slave_sql_with_master.inc
--source include/rpl_end.inc
|
