Debian Codegraph @

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

raw
1 ==== Initialization ====
2 include/master-slave.inc
3 Warnings:
4 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
5 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.
6 [connection master]
7 ---- setup master ----
8 CREATE TABLE myisam_innodb (a INT) ENGINE=MYISAM;
9 CREATE TABLE innodb_myisam (a INT) ENGINE=INNODB;
10 CREATE TABLE myisam_ndb (a INT) ENGINE=MYISAM;
11 CREATE TABLE ndb_myisam (a INT) ENGINE=NDB;
12 CREATE TABLE innodb_ndb (a INT) ENGINE=INNODB;
13 CREATE TABLE ndb_innodb (a INT) ENGINE=NDB;
14 SHOW CREATE TABLE myisam_innodb;
15 Table Create Table
16 myisam_innodb CREATE TABLE `myisam_innodb` (
17 `a` int DEFAULT NULL
18 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
19 SHOW CREATE TABLE innodb_myisam;
20 Table Create Table
21 innodb_myisam CREATE TABLE `innodb_myisam` (
22 `a` int DEFAULT NULL
23 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
24 SHOW CREATE TABLE myisam_ndb;
25 Table Create Table
26 myisam_ndb CREATE TABLE `myisam_ndb` (
27 `a` int DEFAULT NULL
28 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
29 SHOW CREATE TABLE ndb_myisam;
30 Table Create Table
31 ndb_myisam CREATE TABLE `ndb_myisam` (
32 `a` int DEFAULT NULL
33 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
34 SHOW CREATE TABLE innodb_ndb;
35 Table Create Table
36 innodb_ndb CREATE TABLE `innodb_ndb` (
37 `a` int DEFAULT NULL
38 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
39 SHOW CREATE TABLE ndb_innodb;
40 Table Create Table
41 ndb_innodb CREATE TABLE `ndb_innodb` (
42 `a` int DEFAULT NULL
43 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
44 ---- setup slave with different engines ----
45 DROP TABLE myisam_innodb, innodb_myisam;
46 DROP TABLE myisam_ndb, ndb_myisam;
47 DROP TABLE innodb_ndb, ndb_innodb;
48 CREATE TABLE myisam_innodb (a INT) ENGINE=INNODB;
49 CREATE TABLE innodb_myisam (a INT) ENGINE=MYISAM;
50 CREATE TABLE myisam_ndb (a INT) ENGINE=NDB;
51 CREATE TABLE ndb_myisam (a INT) ENGINE=MYISAM;
52 CREATE TABLE innodb_ndb (a INT) ENGINE=NDB;
53 CREATE TABLE ndb_innodb (a INT) ENGINE=INNODB;
54 SHOW CREATE TABLE myisam_innodb;
55 Table Create Table
56 myisam_innodb CREATE TABLE `myisam_innodb` (
57 `a` int DEFAULT NULL
58 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
59 SHOW CREATE TABLE innodb_myisam;
60 Table Create Table
61 innodb_myisam CREATE TABLE `innodb_myisam` (
62 `a` int DEFAULT NULL
63 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
64 SHOW CREATE TABLE myisam_ndb;
65 Table Create Table
66 myisam_ndb CREATE TABLE `myisam_ndb` (
67 `a` int DEFAULT NULL
68 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
69 SHOW CREATE TABLE ndb_myisam;
70 Table Create Table
71 ndb_myisam CREATE TABLE `ndb_myisam` (
72 `a` int DEFAULT NULL
73 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
74 SHOW CREATE TABLE innodb_ndb;
75 Table Create Table
76 innodb_ndb CREATE TABLE `innodb_ndb` (
77 `a` int DEFAULT NULL
78 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
79 SHOW CREATE TABLE ndb_innodb;
80 Table Create Table
81 ndb_innodb CREATE TABLE `ndb_innodb` (
82 `a` int DEFAULT NULL
83 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
84 ==== AUTOCOMMIT=0, transactions ====
85 ---- COMMIT ----
86 SET AUTOCOMMIT = 0;
87 BEGIN;
88 INSERT INTO myisam_innodb VALUES (1);
89 INSERT INTO myisam_innodb VALUES (2);
90 COMMIT;
91 BEGIN;
92 INSERT INTO innodb_myisam VALUES (3);
93 INSERT INTO innodb_myisam VALUES (4);
94 COMMIT;
95 BEGIN;
96 INSERT INTO myisam_ndb VALUES (5);
97 INSERT INTO myisam_ndb VALUES (6);
98 COMMIT;
99 BEGIN;
100 INSERT INTO ndb_myisam VALUES (7);
101 INSERT INTO ndb_myisam VALUES (8);
102 COMMIT;
103 BEGIN;
104 INSERT INTO ndb_innodb VALUES (9);
105 INSERT INTO ndb_innodb VALUES (10);
106 COMMIT;
107 BEGIN;
108 INSERT INTO innodb_ndb VALUES (11);
109 INSERT INTO innodb_ndb VALUES (12);
110 COMMIT;
111 ---- ROLLBACK ----
112 BEGIN;
113 INSERT INTO myisam_innodb VALUES (13);
114 INSERT INTO myisam_innodb VALUES (14);
115 ROLLBACK;
116 Warnings:
117 Warning 1196 Some non-transactional changed tables couldn't be rolled back
118 BEGIN;
119 INSERT INTO innodb_myisam VALUES (15);
120 INSERT INTO innodb_myisam VALUES (16);
121 ROLLBACK;
122 BEGIN;
123 INSERT INTO myisam_ndb VALUES (17);
124 INSERT INTO myisam_ndb VALUES (18);
125 ROLLBACK;
126 Warnings:
127 Warning 1196 Some non-transactional changed tables couldn't be rolled back
128 BEGIN;
129 INSERT INTO ndb_myisam VALUES (19);
130 INSERT INTO ndb_myisam VALUES (20);
131 ROLLBACK;
132 BEGIN;
133 INSERT INTO ndb_innodb VALUES (21);
134 INSERT INTO ndb_innodb VALUES (22);
135 ROLLBACK;
136 BEGIN;
137 INSERT INTO innodb_ndb VALUES (23);
138 INSERT INTO innodb_ndb VALUES (24);
139 ROLLBACK;
140 ==== AUTOCOMMIT=1, transactions ====
141 ---- COMMIT ----
142 SET AUTOCOMMIT = 1;
143 BEGIN;
144 INSERT INTO myisam_innodb VALUES (25);
145 INSERT INTO myisam_innodb VALUES (26);
146 COMMIT;
147 BEGIN;
148 INSERT INTO innodb_myisam VALUES (27);
149 INSERT INTO innodb_myisam VALUES (28);
150 COMMIT;
151 BEGIN;
152 INSERT INTO myisam_ndb VALUES (29);
153 INSERT INTO myisam_ndb VALUES (30);
154 COMMIT;
155 BEGIN;
156 INSERT INTO ndb_myisam VALUES (31);
157 INSERT INTO ndb_myisam VALUES (32);
158 COMMIT;
159 BEGIN;
160 INSERT INTO ndb_innodb VALUES (33);
161 INSERT INTO ndb_innodb VALUES (34);
162 COMMIT;
163 BEGIN;
164 INSERT INTO innodb_ndb VALUES (35);
165 INSERT INTO innodb_ndb VALUES (36);
166 COMMIT;
167 ---- ROLLBACK ----
168 BEGIN;
169 INSERT INTO myisam_innodb VALUES (37);
170 INSERT INTO myisam_innodb VALUES (38);
171 ROLLBACK;
172 Warnings:
173 Warning 1196 Some non-transactional changed tables couldn't be rolled back
174 BEGIN;
175 INSERT INTO innodb_myisam VALUES (39);
176 INSERT INTO innodb_myisam VALUES (40);
177 ROLLBACK;
178 BEGIN;
179 INSERT INTO myisam_ndb VALUES (41);
180 INSERT INTO myisam_ndb VALUES (42);
181 ROLLBACK;
182 Warnings:
183 Warning 1196 Some non-transactional changed tables couldn't be rolled back
184 BEGIN;
185 INSERT INTO ndb_myisam VALUES (43);
186 INSERT INTO ndb_myisam VALUES (44);
187 ROLLBACK;
188 BEGIN;
189 INSERT INTO ndb_innodb VALUES (45);
190 INSERT INTO ndb_innodb VALUES (46);
191 ROLLBACK;
192 BEGIN;
193 INSERT INTO innodb_ndb VALUES (47);
194 INSERT INTO innodb_ndb VALUES (48);
195 ROLLBACK;
196 ==== AUTOCOMMIT=1, single statements ====
197 INSERT INTO myisam_innodb VALUES (49);
198 INSERT INTO myisam_innodb VALUES (50);
199 INSERT INTO innodb_myisam VALUES (51);
200 INSERT INTO innodb_myisam VALUES (52);
201 INSERT INTO myisam_ndb VALUES (53);
202 INSERT INTO myisam_ndb VALUES (54);
203 INSERT INTO ndb_myisam VALUES (55);
204 INSERT INTO ndb_myisam VALUES (56);
205 INSERT INTO ndb_innodb VALUES (57);
206 INSERT INTO ndb_innodb VALUES (58);
207 INSERT INTO innodb_ndb VALUES (59);
208 INSERT INTO innodb_ndb VALUES (60);
209 ==== AUTOCOMMIT=0, single statements, myisam on master ====
210 SET AUTOCOMMIT = 0;
211 INSERT INTO myisam_innodb VALUES (61);
212 INSERT INTO myisam_innodb VALUES (62);
213 INSERT INTO myisam_ndb VALUES (63);
214 INSERT INTO myisam_ndb VALUES (64);
215 ==== Show results ====
216 SELECT * FROM myisam_innodb ORDER BY a;
217 a
218 1
219 2
220 13
221 14
222 25
223 26
224 37
225 38
226 49
227 50
228 61
229 62
230 SELECT * FROM innodb_myisam ORDER BY a;
231 a
232 3
233 4
234 27
235 28
236 51
237 52
238 SELECT * FROM myisam_ndb ORDER BY a;
239 a
240 5
241 6
242 17
243 18
244 29
245 30
246 41
247 42
248 53
249 54
250 63
251 64
252 SELECT * FROM ndb_myisam ORDER BY a;
253 a
254 7
255 8
256 31
257 32
258 55
259 56
260 SELECT * FROM innodb_ndb ORDER BY a;
261 a
262 11
263 12
264 35
265 36
266 59
267 60
268 SELECT * FROM ndb_innodb ORDER BY a;
269 a
270 9
271 10
272 33
273 34
274 57
275 58
276 include/diff_tables.inc [master:myisam_innodb, slave:myisam_innodb]
277 include/diff_tables.inc [master:innodb_myisam, slave:innodb_myisam]
278 include/diff_tables.inc [master:myisam_ndb, slave:myisam_ndb]
279 include/diff_tables.inc [master:ndb_myisam, slave:ndb_myisam]
280 include/diff_tables.inc [master:innodb_ndb, slave:innodb_ndb]
281 include/diff_tables.inc [master:ndb_innodb, slave:ndb_innodb]
282 ==== Clean up ====
283 drop table myisam_innodb, innodb_myisam;
284 drop table myisam_ndb, ndb_myisam;
285 drop table innodb_ndb, ndb_innodb;
286 include/rpl_end.inc