Debian Codegraph @

mysql-test/suite/rpl/r/rpl_transaction_write_set_extraction.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 include/assert.inc [The value for transaction_write_set_extraction must be XXHASH64]
7 CREATE TABLE t1 (a BINARY(1) PRIMARY KEY);
8 SET @debug_saved= @@GLOBAL.DEBUG;
9 SET @@GLOBAL.DEBUG= '+d,PKE_assert_single_primary_key_generated_insert';
10 INSERT INTO t1 VALUES(1);
11 SET @@GLOBAL.DEBUG= @debug_saved;
12 SET @@GLOBAL.DEBUG= '+d,PKE_assert_single_primary_key_generated_update';
13 UPDATE t1 SET a=3 WHERE a=1;
14 SET @@GLOBAL.DEBUG= @debug_saved;
15 include/rpl_sync.inc
16 DROP TABLE t1;
17 include/rpl_sync.inc
18 CREATE TABLE t1 (a BINARY(1), b BINARY(1) PRIMARY KEY INVISIBLE);
19 SELECT * FROM t1;
20 a
21 SET @debug_saved= @@GLOBAL.DEBUG;
22 SET @@GLOBAL.DEBUG= '+d,PKE_assert_single_primary_key_generated_insert';
23 INSERT INTO t1 (a, b) VALUES(0, 1);
24 SET @@GLOBAL.DEBUG= @debug_saved;
25 SET @@GLOBAL.DEBUG= '+d,PKE_assert_single_primary_key_generated_update';
26 UPDATE t1 SET b=3 WHERE b=1;
27 SET @@GLOBAL.DEBUG= @debug_saved;
28 include/rpl_sync.inc
29 DROP TABLE t1;
30 include/rpl_sync.inc
31 CREATE TABLE t1(a BINARY(1), b BINARY(1), PRIMARY KEY(a, b));
32 SET @@GLOBAL.DEBUG= @debug_saved;
33 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multi_primary_key_generated_insert';
34 INSERT INTO t1 VALUE(1, 2);
35 SET @@GLOBAL.DEBUG= @debug_saved;
36 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multi_primary_key_generated_update';
37 UPDATE t1 SET a=3 WHERE a=1;
38 SET @@GLOBAL.DEBUG= @debug_saved;
39 include/rpl_sync.inc
40 DROP TABLE t1;
41 include/rpl_sync.inc
42 CREATE TABLE t1 (c1 BINARY(1) PRIMARY KEY, c2 BINARY(1) NOT NULL UNIQUE, c3 BINARY(1) NOT NULL UNIQUE);
43 SET @@GLOBAL.DEBUG= @debug_saved;
44 SET @@GLOBAL.DEBUG= '+d,PKE_assert_single_primary_unique_key_generated_insert';
45 INSERT INTO t1 VALUES (1, 2, 3);
46 SET @@GLOBAL.DEBUG= @debug_saved;
47 SET @@GLOBAL.DEBUG= '+d,PKE_assert_single_primary_unique_key_generated_update';
48 UPDATE t1 SET c1=5 WHERE c1=1;
49 include/rpl_sync.inc
50 DROP TABLE t1;
51 include/rpl_sync.inc
52 CREATE TABLE t1 (a BINARY(1), d BINARY(1), b BINARY(1) NOT NULL UNIQUE, c BINARY(1) NOT NULL UNIQUE, PRIMARY KEY(a, d));
53 SET @@GLOBAL.DEBUG= @debug_saved;
54 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multi_primary_unique_key_generated_insert';
55 INSERT INTO t1 VALUES(1, 2, 3, 4);
56 SET @@GLOBAL.DEBUG= @debug_saved;
57 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multi_primary_unique_key_generated_update';
58 UPDATE t1 SET a=5 WHERE a=1;
59 SET @@GLOBAL.DEBUG= @debug_saved;
60 include/rpl_sync.inc
61 DROP TABLE t1;
62 include/rpl_sync.inc
63 CREATE TABLE t1 (a BINARY(1), d BINARY(1), b BINARY(1) NOT NULL UNIQUE INVISIBLE, c BINARY(1) NOT NULL UNIQUE INVISIBLE, PRIMARY KEY(a, d));
64 SELECT * FROM t1;
65 a d
66 SET @@GLOBAL.DEBUG= @debug_saved;
67 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multi_primary_unique_key_generated_insert';
68 INSERT INTO t1 (a, d, b, c) VALUES (1, 2, 3, 4);
69 SET @@GLOBAL.DEBUG= @debug_saved;
70 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multi_primary_unique_key_generated_update';
71 UPDATE t1 SET a=5 WHERE a=1;
72 SET @@GLOBAL.DEBUG= @debug_saved;
73 include/rpl_sync.inc
74 DROP TABLE t1;
75 include/rpl_sync.inc
76 CREATE TABLE t1 (a BINARY(1) PRIMARY KEY);
77 CREATE TABLE t2 (b BINARY(1) PRIMARY KEY);
78 CREATE TABLE t3 (c1 BINARY(1), c2 BINARY(1) NOT NULL UNIQUE, PRIMARY KEY(c1, c2), FOREIGN KEY(c1) REFERENCES t1(a), FOREIGN KEY(c2) REFERENCES t2(b));
79 INSERT INTO t1 VALUES (1);
80 INSERT INTO t2 VALUES (5);
81 SET @@GLOBAL.DEBUG= @debug_saved;
82 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multi_foreign_key_generated_insert';
83 INSERT INTO t3 values(1,5);
84 SET @@GLOBAL.DEBUG= @debug_saved;
85 INSERT INTO t1 VALUES (3);
86 include/rpl_sync.inc
87 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multi_foreign_key_generated_update';
88 UPDATE t3 SET c1=3 WHERE c1=1;
89 include/rpl_sync.inc
90 SET @@GLOBAL.DEBUG= @debug_saved;
91 DROP TABLE t3;
92 DROP TABLE t2;
93 DROP TABLE t1;
94 include/rpl_sync.inc
95 CREATE TABLE t1 (c1 BINARY(1) PRIMARY KEY, c2 BINARY(1), UNIQUE KEY(c2));
96 CREATE TABLE t2 (x1 BINARY(1) PRIMARY KEY, x2 BINARY(1), FOREIGN KEY (x2) REFERENCES t1(c2));
97 INSERT INTO t1 VALUES (1,1);
98 SET @@GLOBAL.DEBUG= @debug_saved;
99 SET @@GLOBAL.DEBUG= '+d,PKE_assert_foreign_key_on_referenced_unique_key_parent_generated_insert';
100 INSERT INTO t1 VALUES (2,2);
101 SET @@GLOBAL.DEBUG= @debug_saved;
102 SET @@GLOBAL.DEBUG= '+d,PKE_assert_foreign_key_on_referenced_unique_key_generated_insert';
103 INSERT INTO t2 VALUES (1,1);
104 SET @@GLOBAL.DEBUG= @debug_saved;
105 SET @@GLOBAL.DEBUG= '+d,PKE_assert_foreign_key_on_referenced_unique_key_generated_update';
106 UPDATE t2 SET x2=2 WHERE x1=1;
107 SET @@GLOBAL.DEBUG= @debug_saved;
108 DROP TABLE t2;
109 DROP TABLE t1;
110 include/rpl_sync.inc
111 CREATE TABLE t1 (c1 BINARY(1) PRIMARY KEY, c2 BINARY(1) INVISIBLE, UNIQUE KEY(c2));
112 SELECT * FROM t1;
113 c1
114 CREATE TABLE t2 (x1 BINARY(1) PRIMARY KEY, x2 BINARY(1) INVISIBLE, FOREIGN KEY (x2) REFERENCES t1(c2));
115 SELECT * FROM t2;
116 x1
117 INSERT INTO t1 (c1, c2) VALUES (1,1);
118 SET @@GLOBAL.DEBUG= @debug_saved;
119 SET @@GLOBAL.DEBUG= '+d,PKE_assert_foreign_key_on_referenced_unique_key_parent_generated_insert';
120 INSERT INTO t1 (c1, c2) VALUES (2,2);
121 SET @@GLOBAL.DEBUG= @debug_saved;
122 SET @@GLOBAL.DEBUG= '+d,PKE_assert_foreign_key_on_referenced_unique_key_generated_insert';
123 INSERT INTO t2 (x1, x2) VALUES (1,1);
124 SET @@GLOBAL.DEBUG= @debug_saved;
125 SET @@GLOBAL.DEBUG= '+d,PKE_assert_foreign_key_on_referenced_unique_key_generated_update';
126 UPDATE t2 SET x2=2 WHERE x1=1;
127 SET @@GLOBAL.DEBUG= @debug_saved;
128 DROP TABLE t2;
129 DROP TABLE t1;
130 include/rpl_sync.inc
131 CREATE TABLE t1 (c1 BINARY(1) PRIMARY KEY, c2 BINARY(1), KEY(c2));
132 CREATE TABLE t2 (x1 BINARY(1) PRIMARY KEY, x2 BINARY(1), FOREIGN KEY (x2) REFERENCES t1(c2));
133 INSERT INTO t1 VALUES (1,1);
134 SET @@GLOBAL.DEBUG= @debug_saved;
135 SET @@GLOBAL.DEBUG= '+d,PKE_assert_foreign_key_on_referenced_non_unique_key_parent_generated_insert';
136 INSERT INTO t1 VALUES (2,2);
137 SET @@GLOBAL.DEBUG= @debug_saved;
138 SET @@GLOBAL.DEBUG= '+d,PKE_assert_foreign_key_on_referenced_non_unique_key_generated_insert';
139 INSERT INTO t2 VALUES (1,1);
140 SET @@GLOBAL.DEBUG= @debug_saved;
141 SET @@GLOBAL.DEBUG= '+d,PKE_assert_foreign_key_on_referenced_non_unique_key_generated_update';
142 UPDATE t2 SET x2=2 WHERE x1=1;
143 SET @@GLOBAL.DEBUG= @debug_saved;
144 DROP TABLE t2;
145 DROP TABLE t1;
146 include/rpl_sync.inc
147 CREATE TABLE t1(a BINARY(1), b BINARY(1), c BINARY(1), PRIMARY KEY (a,b,c));
148 CREATE TABLE t2(d BINARY(1), e BINARY(1), f BINARY(1), PRIMARY KEY (d,e,f), CONSTRAINT foreign_key_t2_t1 FOREIGN KEY (d,e,f) REFERENCES t1(a,b,c));
149 INSERT INTO t1 VALUES (1,2,3);
150 INSERT INTO t1 VALUES (4,2,3);
151 SET @@GLOBAL.DEBUG= @debug_saved;
152 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multi_column_foreign_key_on_multiple_column_primary_key_insert';
153 INSERT INTO t2 VALUES (1,2,3);
154 SET @@GLOBAL.DEBUG= @debug_saved;
155 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multi_column_foreign_key_on_multiple_column_primary_key_update';
156 UPDATE t2 SET d=4 WHERE d=1;
157 SET @@GLOBAL.DEBUG= @debug_saved;
158 DROP TABLE t2;
159 DROP TABLE t1;
160 include/rpl_sync.inc
161 CREATE TABLE t1 (a BINARY(1) PRIMARY KEY, b BINARY(1) NOT NULL, c BINARY(1) NOT NULL, UNIQUE KEY key_b_c(b,c));
162 CREATE TABLE t2 (d BINARY(1) PRIMARY KEY, e BINARY(1) NOT NULL, f BINARY(1) NOT NULL, UNIQUE KEY key_e_f(e,f), FOREIGN KEY(e,f) REFERENCES t1(b,c));
163 SET @@GLOBAL.DEBUG= @debug_saved;
164 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multiple_column_unique_key_insert';
165 INSERT INTO t1 VALUES (1,2,3);
166 SET @@GLOBAL.DEBUG= @debug_saved;
167 INSERT INTO t1 VALUES (4,5,6);
168 SET @@GLOBAL.DEBUG= @debug_saved;
169 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multi_column_foreign_key_on_multiple_column_unique_key_insert';
170 INSERT INTO t2 VALUES (1,2,3);
171 SET @@GLOBAL.DEBUG= @debug_saved;
172 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multi_column_foreign_key_on_multiple_column_unique_key_update';
173 UPDATE t2 SET d=4,e=5,f=6 WHERE d=1;
174 SET @@GLOBAL.DEBUG= @debug_saved;
175 DROP TABLE t2;
176 DROP TABLE t1;
177 include/rpl_sync.inc
178 CREATE TABLE t1(a VARCHAR(64), PRIMARY KEY(a(4)));
179 INSERT INTO t1 VALUES ('aaaaxxxx');
180 SET @@GLOBAL.DEBUG= @debug_saved;
181 SET @@GLOBAL.DEBUG= '+d,PKE_assert_single_primary_key_part_insert';
182 INSERT INTO t1 VALUES ('ddddxxxx');
183 SET @@GLOBAL.DEBUG= @debug_saved;
184 SET @@GLOBAL.DEBUG= '+d,PKE_assert_single_primary_key_part_update';
185 UPDATE t1 SET a = 'bbbbxxxx' WHERE a = 'ddddxxxx';
186 SET @@GLOBAL.DEBUG= @debug_saved;
187 DROP TABLE t1;
188 include/rpl_sync.inc
189 CREATE TABLE t1(a VARCHAR(64), b VARCHAR(64), PRIMARY KEY(a(4), b(4)));
190 INSERT INTO t1 VALUES ('aaaaxxxx', 'bbbbxxxx');
191 SET @@GLOBAL.DEBUG= @debug_saved;
192 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multiple_primary_key_part_insert';
193 INSERT INTO t1 VALUES ('aaaaxxxx', 'ccccxxxx');
194 SET @@GLOBAL.DEBUG= @debug_saved;
195 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multiple_primary_key_part_update';
196 UPDATE t1 SET b = 'ddddxxxx' WHERE b = 'ccccxxxx';
197 SET @@GLOBAL.DEBUG= @debug_saved;
198 DROP TABLE t1;
199 include/rpl_sync.inc
200 CREATE TABLE t1(p BINARY, a VARCHAR(64), PRIMARY KEY(p), UNIQUE KEY(a(4)));
201 INSERT INTO t1 VALUES (1, 'aaaaxxxx');
202 SET @@GLOBAL.DEBUG= @debug_saved;
203 SET @@GLOBAL.DEBUG= '+d,PKE_assert_single_unique_key_part_insert';
204 INSERT INTO t1 VALUES (2, 'bbbbxxxx');
205 SET @@GLOBAL.DEBUG= @debug_saved;
206 SET @@GLOBAL.DEBUG= '+d,PKE_assert_single_unique_key_part_update';
207 UPDATE t1 SET a = 'ddddxxxx' WHERE a = 'bbbbxxxx';
208 SET @@GLOBAL.DEBUG= @debug_saved;
209 DROP TABLE t1;
210 include/rpl_sync.inc
211 CREATE TABLE t1(p BINARY, a VARCHAR(64), b VARCHAR(64), PRIMARY KEY(p), UNIQUE KEY(a(4), b(4)));
212 INSERT INTO t1 VALUES (1, 'aaaaxxxx', 'bbbbxxxx');
213 SET @@GLOBAL.DEBUG= @debug_saved;
214 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multiple_unique_key_part_insert';
215 INSERT INTO t1 VALUES (2, 'aaaaxxxx', 'ccccxxxx');
216 SET @@GLOBAL.DEBUG= @debug_saved;
217 SET @@GLOBAL.DEBUG= '+d,PKE_assert_multiple_unique_key_part_update';
218 UPDATE t1 SET b = 'ddddxxxx' WHERE b = 'ccccxxxx';
219 SET @@GLOBAL.DEBUG= @debug_saved;
220 DROP TABLE t1;
221 include/rpl_sync.inc
222 include/rpl_end.inc