Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_multi_update_of_same_row.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 [connection slave]
7 SET @saved_slave_rows_search_algorithms= @@global.slave_rows_search_algorithms;
8 Warnings:
9 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
10 [connection master]
11 CREATE TABLE t1 (i INT);
12 CREATE TABLE t2 (j INT NOT NULL PRIMARY KEY);
13 CREATE FUNCTION f1 () RETURNS INT BEGIN
14 UPDATE t1 SET i = 2 WHERE i = 1;
15 UPDATE t1 SET i = 3 WHERE i = 2;
16 UPDATE t1 SET i = 4 WHERE i = 3;
17 UPDATE t1 SET i = 5 WHERE i = 4;
18 UPDATE t2 SET j = 2 WHERE j = 1;
19 UPDATE t2 SET j = 3 WHERE j = 2;
20 UPDATE t2 SET j = 4 WHERE j = 3;
21 UPDATE t2 SET j = 5 WHERE j = 4;
22 RETURN 0;
23 END|
24 include/sync_slave_sql_with_master.inc
25 SET GLOBAL slave_rows_search_algorithms= 'HASH_SCAN';
26 Warnings:
27 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
28 [connection master]
29 INSERT INTO t1 VALUES (1);
30 INSERT INTO t2 VALUES (1);
31 SELECT f1();
32 f1()
33 0
34 include/sync_slave_sql_with_master.inc
35 include/assert.inc ['There is only one row in table t1']
36 include/assert.inc ['There is only one row in table t2']
37 [connection master]
38 include/diff_tables.inc [master:test.t1, slave:test.t1]
39 include/diff_tables.inc [master:test.t2, slave:test.t2]
40 TRUNCATE TABLE t1;
41 TRUNCATE TABLE t2;
42 include/sync_slave_sql_with_master.inc
43 SET GLOBAL slave_rows_search_algorithms= 'TABLE_SCAN';
44 Warnings:
45 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
46 [connection master]
47 INSERT INTO t1 VALUES (1);
48 INSERT INTO t2 VALUES (1);
49 SELECT f1();
50 f1()
51 0
52 include/sync_slave_sql_with_master.inc
53 include/assert.inc ['There is only one row in table t1']
54 include/assert.inc ['There is only one row in table t2']
55 [connection master]
56 include/diff_tables.inc [master:test.t1, slave:test.t1]
57 include/diff_tables.inc [master:test.t2, slave:test.t2]
58 TRUNCATE TABLE t1;
59 TRUNCATE TABLE t2;
60 include/sync_slave_sql_with_master.inc
61 SET GLOBAL slave_rows_search_algorithms= 'INDEX_SCAN';
62 Warnings:
63 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
64 [connection master]
65 INSERT INTO t1 VALUES (1);
66 INSERT INTO t2 VALUES (1);
67 SELECT f1();
68 f1()
69 0
70 include/sync_slave_sql_with_master.inc
71 include/assert.inc ['There is only one row in table t1']
72 include/assert.inc ['There is only one row in table t2']
73 [connection master]
74 include/diff_tables.inc [master:test.t1, slave:test.t1]
75 include/diff_tables.inc [master:test.t2, slave:test.t2]
76 TRUNCATE TABLE t1;
77 TRUNCATE TABLE t2;
78 include/sync_slave_sql_with_master.inc
79 SET GLOBAL slave_rows_search_algorithms= 'HASH_SCAN,TABLE_SCAN';
80 Warnings:
81 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
82 [connection master]
83 INSERT INTO t1 VALUES (1);
84 INSERT INTO t2 VALUES (1);
85 SELECT f1();
86 f1()
87 0
88 include/sync_slave_sql_with_master.inc
89 include/assert.inc ['There is only one row in table t1']
90 include/assert.inc ['There is only one row in table t2']
91 [connection master]
92 include/diff_tables.inc [master:test.t1, slave:test.t1]
93 include/diff_tables.inc [master:test.t2, slave:test.t2]
94 TRUNCATE TABLE t1;
95 TRUNCATE TABLE t2;
96 include/sync_slave_sql_with_master.inc
97 SET GLOBAL slave_rows_search_algorithms= 'HASH_SCAN,INDEX_SCAN';
98 Warnings:
99 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
100 [connection master]
101 INSERT INTO t1 VALUES (1);
102 INSERT INTO t2 VALUES (1);
103 SELECT f1();
104 f1()
105 0
106 include/sync_slave_sql_with_master.inc
107 include/assert.inc ['There is only one row in table t1']
108 include/assert.inc ['There is only one row in table t2']
109 [connection master]
110 include/diff_tables.inc [master:test.t1, slave:test.t1]
111 include/diff_tables.inc [master:test.t2, slave:test.t2]
112 TRUNCATE TABLE t1;
113 TRUNCATE TABLE t2;
114 include/sync_slave_sql_with_master.inc
115 SET GLOBAL slave_rows_search_algorithms= 'TABLE_SCAN,INDEX_SCAN';
116 Warnings:
117 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
118 [connection master]
119 INSERT INTO t1 VALUES (1);
120 INSERT INTO t2 VALUES (1);
121 SELECT f1();
122 f1()
123 0
124 include/sync_slave_sql_with_master.inc
125 include/assert.inc ['There is only one row in table t1']
126 include/assert.inc ['There is only one row in table t2']
127 [connection master]
128 include/diff_tables.inc [master:test.t1, slave:test.t1]
129 include/diff_tables.inc [master:test.t2, slave:test.t2]
130 TRUNCATE TABLE t1;
131 TRUNCATE TABLE t2;
132 include/sync_slave_sql_with_master.inc
133 SET GLOBAL slave_rows_search_algorithms= 'HASH_SCAN,TABLE_SCAN,INDEX_SCAN';
134 Warnings:
135 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
136 [connection master]
137 INSERT INTO t1 VALUES (1);
138 INSERT INTO t2 VALUES (1);
139 SELECT f1();
140 f1()
141 0
142 include/sync_slave_sql_with_master.inc
143 include/assert.inc ['There is only one row in table t1']
144 include/assert.inc ['There is only one row in table t2']
145 [connection master]
146 include/diff_tables.inc [master:test.t1, slave:test.t1]
147 include/diff_tables.inc [master:test.t2, slave:test.t2]
148 TRUNCATE TABLE t1;
149 TRUNCATE TABLE t2;
150 include/sync_slave_sql_with_master.inc
151 [connection master]
152 DROP FUNCTION f1;
153 DROP TABLE t1,t2;
154 [connection slave]
155 SET GLOBAL slave_rows_search_algorithms= @saved_slave_rows_search_algorithms;
156 Warnings:
157 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
158 include/rpl_end.inc