Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_idempotent_hash_scan.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 **** On Master ****
7 CREATE TABLE t1 (C1 CHAR(1), C2 CHAR(1), KEY(C1, C2)) ENGINE = ndb;
8 CREATE TABLE t2 (C1 CHAR(1), C2 CHAR(1), KEY(C1, C2)) ENGINE = ndb;
9 CREATE TABLE t3 (C1 CHAR(1), C2 CHAR(1), KEY(C1, C2)) ENGINE = ndb;
10 INSERT INTO t1 VALUES ('K','K'), ('L','L'), ('M','M'), ('N','N');
11 INSERT INTO t2 VALUES ('K','K'), ('L','L'), ('M','M'), ('N','N');
12 INSERT INTO t3 VALUES ('K','K'), ('L','L'), ('M','M'), ('N','N');
13 include/sync_slave_sql_with_master.inc
14 **** On Slave ****
15 set @prior_replica_exec_mode=@@global.replica_exec_mode;
16 set @prior_slave_rows_search_algorithms=@@global.slave_rows_search_algorithms;
17 Warnings:
18 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
19 set @prior_replica_allow_batching=@@global.replica_allow_batching;
20 set @@global.replica_exec_mode= 'IDEMPOTENT';
21 set @@global.slave_rows_search_algorithms= 'HASH_SCAN';
22 Warnings:
23 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
24 set @@global.replica_allow_batching = OFF;
25 include/restart_slave.inc
26 DELETE FROM t1 WHERE C1 = 'L';
27 DELETE FROM t2 WHERE C1 = 'L';
28 DELETE FROM t3 WHERE C1 = 'K';
29 **** On Master ****
30 DELETE FROM t1;
31 include/sync_slave_sql_with_master.inc
32 include/check_slave_is_running.inc
33 **** On Slave ; expect count to be 0 ****
34 SELECT COUNT(*) FROM t1 ORDER BY c1,c2;
35 COUNT(*)
36 0
37 **** On Master ****
38 DELETE FROM t2;
39 DELETE FROM t3;
40 include/sync_slave_sql_with_master.inc
41 include/check_slave_is_running.inc
42 **** On Slave ; expect count to be 0 ****
43 SELECT COUNT(*) FROM t2 ORDER BY c1,c2;
44 COUNT(*)
45 0
46 SELECT COUNT(*) FROM t3 ORDER BY c1,c2;
47 COUNT(*)
48 0
49 **** On Master ****
50 drop table t1, t2, t3;
51 **** Cleanup on Slave ****
52 set @@global.replica_exec_mode= @prior_replica_exec_mode;
53 set @@global.slave_rows_search_algorithms= @prior_slave_rows_search_algorithms;
54 Warnings:
55 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
56 set @@global.replica_allow_batching= @prior_replica_allow_batching;
57 call mtr.add_suppression("Replica SQL.*Could not execute Delete_rows event on table test.t.* Error_code: 1032");
58 include/rpl_end.inc