Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_hash_scan_sanity.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 CREATE TABLE t1 (c1 INT);
7 CREATE TABLE t2 (c1 INT PRIMARY KEY);
8 CREATE TABLE t3 (c1 INT UNIQUE KEY NOT NULL);
9 CREATE TABLE t4 (c1 INT KEY);
10 INSERT INTO t1 VALUES (1);
11 INSERT INTO t2 VALUES (1);
12 INSERT INTO t3 VALUES (1);
13 INSERT INTO t4 VALUES (1);
14 include/sync_slave_sql_with_master.inc
15 SET @saved_slave_rows_search_algorithms= @@global.slave_rows_search_algorithms;
16 Warnings:
17 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
18 SET @@global.slave_rows_search_algorithms= 'TABLE_SCAN';
19 Warnings:
20 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
21 UPDATE t1 SET c1= 2;
22 UPDATE t2 SET c1= 2;
23 UPDATE t3 SET c1= 2;
24 UPDATE t4 SET c1= 2;
25 SET @@global.slave_rows_search_algorithms= 'TABLE_SCAN,INDEX_SCAN';
26 Warnings:
27 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
28 UPDATE t1 SET c1= 3;
29 UPDATE t2 SET c1= 3;
30 UPDATE t3 SET c1= 3;
31 UPDATE t4 SET c1= 3;
32 SET @@global.slave_rows_search_algorithms= 'TABLE_SCAN,HASH_SCAN';
33 Warnings:
34 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
35 UPDATE t1 SET c1= 4;
36 UPDATE t2 SET c1= 4;
37 UPDATE t3 SET c1= 4;
38 UPDATE t4 SET c1= 4;
39 SET @@global.slave_rows_search_algorithms= 'HASH_SCAN';
40 Warnings:
41 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
42 UPDATE t1 SET c1= 5;
43 UPDATE t2 SET c1= 5;
44 UPDATE t3 SET c1= 5;
45 UPDATE t4 SET c1= 5;
46 SET @@global.slave_rows_search_algorithms= 'HASH_SCAN,INDEX_SCAN';
47 Warnings:
48 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
49 UPDATE t1 SET c1= 6;
50 UPDATE t2 SET c1= 6;
51 UPDATE t3 SET c1= 6;
52 UPDATE t4 SET c1= 6;
53 SET @@global.slave_rows_search_algorithms= 'HASH_SCAN,INDEX_SCAN,TABLE_SCAN';
54 Warnings:
55 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
56 UPDATE t1 SET c1= 7;
57 UPDATE t2 SET c1= 7;
58 UPDATE t3 SET c1= 7;
59 UPDATE t4 SET c1= 7;
60 SET @@global.slave_rows_search_algorithms= 'HASH_SCAN';
61 Warnings:
62 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
63 CREATE TABLE t5(c1 INT, c2 INT, KEY(c2));
64 INSERT INTO t5 VALUES (1,1),(2,2),(3,1),(4,NULL),(5,2),(6,3);
65 DELETE FROM t5 ORDER BY c1;
66 DROP TABLE t5;
67 include/sync_slave_sql_with_master.inc
68 CREATE TABLE t5(c1 BIGINT, c2 BIGINT, KEY(c2));
69 INSERT INTO t5 VALUES (1,1),(2,2),(3,1),(4,NULL),(5,2),(6,3);
70 DELETE FROM t5 ORDER BY c1;
71 DROP TABLE t5;
72 include/sync_slave_sql_with_master.inc
73 CREATE TABLE t5(c1 INT, c2 VARCHAR(20), KEY(c2));
74 INSERT INTO t5 VALUES (1,"value1"),(2,"value2"),(3,"value1"),(4,NULL),(5,"value2"),(6,"value3");
75 DELETE FROM t5 ORDER BY c1;
76 DROP TABLE t5;
77 include/sync_slave_sql_with_master.inc
78 CREATE TABLE t5(c1 INT, c2 INT, c3 VARCHAR(20), KEY(c2,c3));
79 INSERT INTO t5 VALUES (1,1,"ab"),(2,2,"cde"),(3,1,"12345"),(4,4,"random"),(5,NULL,NULL),(6,5,NULL),(7,NULL,"lmnopqr");
80 DELETE FROM t5 ORDER BY c1;
81 DROP TABLE t5;
82 include/sync_slave_sql_with_master.inc
83 SET @@global.slave_rows_search_algorithms= 'INDEX_SCAN,HASH_SCAN';
84 Warnings:
85 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
86 call mtr.add_suppression("Could not execute Delete_rows event on table test.t6");
87 call mtr.add_suppression("Could not execute Update_rows event on table test.t6");
88 call mtr.add_suppression("Can't find record in 't6'");
89 call mtr.add_suppression("The replica coordinator and worker threads are stopped");
90 [connection master]
91 CREATE TABLE t6(num INT, year INT, KEY year (year))
92 PARTITION BY HASH(num) PARTITIONS 5;
93 INSERT INTO t6 VALUES(6, 1977);
94 INSERT INTO t6 VALUES(1, 1983);
95 INSERT INTO t6 VALUES(9, 1977);
96 DELETE FROM t6 WHERE num= 9;
97 include/sync_slave_sql_with_master.inc
98 [connection master]
99 include/diff_tables.inc [master:t6, slave:t6]
100 DROP TABLE t6;
101 include/sync_slave_sql_with_master.inc
102 [connection master]
103 CREATE TABLE t6(num INT, year INT, KEY year (year))
104 PARTITION BY HASH(num) PARTITIONS 5;
105 INSERT INTO t6 VALUES(6, 1977);
106 INSERT INTO t6 VALUES(1, 1983);
107 INSERT INTO t6 VALUES(9, 1977);
108 INSERT INTO t6 VALUES(9, 1977);
109 INSERT INTO t6 VALUES(9, 1987);
110 INSERT INTO t6 VALUES(9, 9);
111 INSERT INTO t6 VALUES(9, 1555555500);
112 DELETE FROM t6 WHERE num= 9;
113 include/sync_slave_sql_with_master.inc
114 [connection master]
115 include/diff_tables.inc [master:t6, slave:t6]
116 DROP TABLE t6;
117 include/sync_slave_sql_with_master.inc
118 [connection master]
119 CREATE TABLE t6(num INT, year INT, num_2 INT, KEY year (year))
120 PARTITION BY HASH(num_2-num) PARTITIONS 5;
121 INSERT INTO t6 VALUES(6, 1977, 1);
122 INSERT INTO t6 VALUES(1, 1983, 2);
123 INSERT INTO t6 VALUES(9, 1977, 1);
124 INSERT INTO t6 VALUES(9, 1983, 1);
125 INSERT INTO t6 VALUES(9, 1977, 3);
126 DELETE FROM t6 WHERE num_2= 1;
127 include/sync_slave_sql_with_master.inc
128 [connection master]
129 include/diff_tables.inc [master:t6, slave:t6]
130 DROP TABLE t6;
131 include/sync_slave_sql_with_master.inc
132 include/stop_slave_sql.inc
133 [connection master]
134 CREATE TABLE t6(num INT, year INT, KEY year (year))
135 PARTITION BY HASH(num) PARTITIONS 5;
136 INSERT INTO t6 VALUES(6, 1977);
137 INSERT INTO t6 VALUES(1, 1983);
138 INSERT INTO t6 VALUES(9, 1977);
139 SET SQL_LOG_BIN= 0;
140 INSERT INTO t6 VALUES(10, 1977);
141 SET SQL_LOG_BIN= 1;
142 DELETE FROM t6 WHERE num= 10;
143 [connection slave]
144 START SLAVE SQL_THREAD;
145 Warnings:
146 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
147 include/wait_for_slave_sql_error.inc [errno=1032]
148 include/stop_slave.inc
149 INSERT INTO t6 VALUES(10, 1977);
150 include/start_slave.inc
151 [connection master]
152 DROP TABLE t6;
153 include/sync_slave_sql_with_master.inc
154 [connection master]
155 CREATE TABLE t6(num INT, year INT, KEY year (year))
156 PARTITION BY HASH(num) PARTITIONS 5;
157 INSERT INTO t6 VALUES(6, 1977);
158 INSERT INTO t6 VALUES(1, 1983);
159 INSERT INTO t6 VALUES(9, 1977);
160 UPDATE t6 SET num= 10 WHERE num= 9;
161 include/sync_slave_sql_with_master.inc
162 [connection master]
163 include/diff_tables.inc [master:t6, slave:t6]
164 DROP TABLE t6;
165 include/sync_slave_sql_with_master.inc
166 [connection master]
167 CREATE TABLE t6(num INT, year INT, KEY year (year))
168 PARTITION BY HASH(num) PARTITIONS 5;
169 INSERT INTO t6 VALUES(6, 1977);
170 INSERT INTO t6 VALUES(1, 1983);
171 INSERT INTO t6 VALUES(9, 1977);
172 INSERT INTO t6 VALUES(9, 1977);
173 INSERT INTO t6 VALUES(9, 1987);
174 INSERT INTO t6 VALUES(9, 9);
175 INSERT INTO t6 VALUES(9, 1555555500);
176 UPDATE t6 SET num= 10 WHERE num= 9;
177 include/sync_slave_sql_with_master.inc
178 [connection master]
179 include/diff_tables.inc [master:t6, slave:t6]
180 DROP TABLE t6;
181 include/sync_slave_sql_with_master.inc
182 [connection master]
183 CREATE TABLE t6(num INT, year INT, num_2 INT, KEY year (year))
184 PARTITION BY HASH(num_2-num) PARTITIONS 5;
185 INSERT INTO t6 VALUES(6, 1977, 1);
186 INSERT INTO t6 VALUES(1, 1983, 2);
187 INSERT INTO t6 VALUES(9, 1977, 1);
188 INSERT INTO t6 VALUES(9, 1983, 1);
189 INSERT INTO t6 VALUES(9, 1977, 3);
190 UPDATE t6 SET num= 10 WHERE num_2= 1;
191 include/sync_slave_sql_with_master.inc
192 [connection master]
193 include/diff_tables.inc [master:t6, slave:t6]
194 DROP TABLE t6;
195 include/sync_slave_sql_with_master.inc
196 include/stop_slave_sql.inc
197 [connection master]
198 CREATE TABLE t6(num INT, year INT, KEY year (year))
199 PARTITION BY HASH(num) PARTITIONS 5;
200 INSERT INTO t6 VALUES(6, 1977);
201 INSERT INTO t6 VALUES(1, 1983);
202 INSERT INTO t6 VALUES(9, 1977);
203 SET SQL_LOG_BIN= 0;
204 INSERT INTO t6 VALUES(10, 1977);
205 SET SQL_LOG_BIN= 1;
206 UPDATE t6 SET num= 9 WHERE num= 10;
207 [connection slave]
208 START SLAVE SQL_THREAD;
209 Warnings:
210 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
211 include/wait_for_slave_sql_error.inc [errno=1032]
212 include/stop_slave.inc
213 INSERT INTO t6 VALUES(10, 1977);
214 include/start_slave.inc
215 [connection master]
216 DROP TABLE t6;
217 include/sync_slave_sql_with_master.inc
218 SET @@global.slave_rows_search_algorithms= @saved_slave_rows_search_algorithms;
219 Warnings:
220 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
221 DROP TABLE IF EXISTS t1, t2, t3, t4;
222 include/sync_slave_sql_with_master.inc
223 include/rpl_reset.inc
224 include/rpl_end.inc