Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_slave_skip_myisam.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 Slave ****
7 STOP SLAVE;
8 Warnings:
9 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
10 include/wait_for_slave_to_stop.inc
11 **** On Master ****
12 SET SESSION BINLOG_FORMAT='ROW';
13 Warnings:
14 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
15 CREATE TABLE t1 (a INT, b INT) ENGINE=MyISAM;
16 CREATE TABLE t2 (c INT, d INT) ENGINE=MyISAM;
17 INSERT INTO t1 VALUES (1,1),(2,4),(3,9);
18 INSERT INTO t2 VALUES (1,1),(2,8),(3,27);
19 UPDATE t1,t2 SET b = d, d = b * 2 WHERE a = c;
20 include/show_binlog_events.inc
21 Log_name Pos Event_type Server_id End_log_pos Info
22 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT, b INT) ENGINE=MyISAM
23 master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (c INT, d INT) ENGINE=MyISAM
24 master-bin.000001 # Query # # BEGIN
25 master-bin.000001 # Table_map # # table_id: # (test.t1)
26 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
27 master-bin.000001 # Query # # COMMIT
28 master-bin.000001 # Query # # BEGIN
29 master-bin.000001 # Table_map # # table_id: # (test.t2)
30 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
31 master-bin.000001 # Query # # COMMIT
32 master-bin.000001 # Query # # BEGIN
33 master-bin.000001 # Table_map # # table_id: # (test.t1)
34 master-bin.000001 # Table_map # # table_id: # (test.t2)
35 master-bin.000001 # Update_rows # # table_id: #
36 master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
37 master-bin.000001 # Query # # COMMIT
38 SELECT * FROM t1;
39 a b
40 1 1
41 2 8
42 3 27
43 SELECT * FROM t2;
44 c d
45 1 2
46 2 16
47 3 54
48 **** On Slave ****
49 START SLAVE UNTIL SOURCE_LOG_FILE='master-bin.000001', SOURCE_LOG_POS=MASTER_LOG_POS;
50 Warnings:
51 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
52 include/wait_for_slave_sql_to_stop.inc
53 include/check_slave_param.inc [Exec_Master_Log_Pos]
54 include/check_slave_no_error.inc
55 SET GLOBAL SQL_REPLICA_SKIP_COUNTER=2;
56 START SLAVE;
57 Warnings:
58 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
59 include/wait_for_slave_to_start.inc
60 SELECT * FROM t1;
61 a b
62 1 1
63 2 4
64 3 9
65 SELECT * FROM t2;
66 c d
67 1 1
68 2 8
69 3 27
70 STOP SLAVE;
71 Warnings:
72 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
73 include/wait_for_slave_to_stop.inc
74 RESET SLAVE;
75 Warnings:
76 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
77 RESET MASTER;
78 SET SESSION BINLOG_FORMAT=STATEMENT;
79 Warnings:
80 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
81 SET @foo = 12;
82 INSERT INTO t1 VALUES(@foo, 2*@foo);
83 include/show_binlog_events.inc
84 Log_name Pos Event_type Server_id End_log_pos Info
85 master-bin.000001 # Query # # BEGIN
86 master-bin.000001 # User var # # @`foo`=12
87 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES(@foo, 2*@foo)
88 master-bin.000001 # Query # # COMMIT
89 START SLAVE UNTIL SOURCE_LOG_FILE='master-bin.000001', SOURCE_LOG_POS=MASTER_LOG_POS;
90 Warnings:
91 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
92 include/wait_for_slave_sql_to_stop.inc
93 SET GLOBAL SQL_REPLICA_SKIP_COUNTER=2;
94 START SLAVE;
95 Warnings:
96 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
97 include/wait_for_slave_to_start.inc
98 **** On Master ****
99 DROP TABLE t1, t2;
100 include/sync_slave_sql_with_master.inc
101 SET SESSION BINLOG_FORMAT='ROW';
102 Warnings:
103 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
104 SET AUTOCOMMIT=0;
105 CREATE TABLE t1 (a INT, b VARCHAR(20)) ENGINE=myisam;
106 CREATE TABLE t2 (a INT, b VARCHAR(20)) ENGINE=myisam;
107 CREATE TABLE t3 (a INT, b VARCHAR(20)) ENGINE=myisam;
108 INSERT INTO t1 VALUES (1,'master/slave');
109 INSERT INTO t2 VALUES (1,'master/slave');
110 INSERT INTO t3 VALUES (1,'master/slave');
111 CREATE TRIGGER tr1 AFTER UPDATE on t1 FOR EACH ROW
112 BEGIN
113 INSERT INTO t2 VALUES (NEW.a,NEW.b);
114 DELETE FROM t2 WHERE a < NEW.a;
115 END|
116 CREATE TRIGGER tr2 AFTER INSERT on t2 FOR EACH ROW
117 BEGIN
118 UPDATE t3 SET a =2, b = 'master only';
119 END|
120 **** On Slave ****
121 include/sync_slave_sql_with_master.inc
122 include/stop_slave.inc
123 **** On Master ****
124 UPDATE t1 SET a = 2, b = 'master only' WHERE a = 1;
125 DROP TRIGGER tr1;
126 DROP TRIGGER tr2;
127 INSERT INTO t1 VALUES (3,'master/slave');
128 INSERT INTO t2 VALUES (3,'master/slave');
129 INSERT INTO t3 VALUES (3,'master/slave');
130 COMMIT;
131 SELECT * FROM t1 ORDER BY a;
132 a b
133 2 master only
134 3 master/slave
135 SELECT * FROM t2 ORDER BY a;
136 a b
137 2 master only
138 3 master/slave
139 SELECT * FROM t3 ORDER BY a;
140 a b
141 2 master only
142 3 master/slave
143 *** On Slave ***
144 SET GLOBAL SQL_REPLICA_SKIP_COUNTER=2;
145 include/start_slave.inc
146 SELECT * FROM t1 ORDER BY a;
147 a b
148 1 master/slave
149 3 master/slave
150 SELECT * FROM t2 ORDER BY a;
151 a b
152 1 master/slave
153 3 master/slave
154 SELECT * FROM t3 ORDER BY a;
155 a b
156 1 master/slave
157 3 master/slave
158 DROP TABLE t1, t2, t3;
159 include/sync_slave_sql_with_master.inc
160 **** Case 3: Statement logging format and LOAD DATA with non-transactional table ****
161 *** On Master ***
162 CREATE TABLE t10 (a INT, b VARCHAR(20)) ENGINE=myisam;
163 *** On Slave ***
164 include/sync_slave_sql_with_master.inc
165 include/stop_slave.inc
166 *** On Master ***
167 SET SESSION BINLOG_FORMAT=STATEMENT;
168 Warnings:
169 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
170 LOAD DATA INFILE 'MYSQLTEST_VARDIR/std_data/rpl_bug28618.dat' INTO TABLE t10 FIELDS TERMINATED BY '|';
171 SELECT * FROM t10 ORDER BY a;
172 a b
173 1 master only
174 2 master only
175 3 master only
176 *** On Slave ***
177 SET GLOBAL SQL_REPLICA_SKIP_COUNTER=2;
178 include/start_slave.inc
179 SELECT * FROM t10 ORDER BY a;
180 a b
181 DROP TABLE t10;
182 include/sync_slave_sql_with_master.inc
183 include/rpl_end.inc