Debian Codegraph @

mysql-test/suite/galera/r/mariadb_tzinfo_to_sql.result

raw
1 connection node_2;
2 connection node_1;
3 #
4 # MDEV-28263: mariadb-tzinfo-to-sql improve wsrep and binlog cases
5 #
6
7 # On node_1
8 connection node_1;
9 CREATE TABLE time_zone LIKE mysql.time_zone;
10 CREATE TABLE time_zone_name LIKE mysql.time_zone_name;
11 CREATE TABLE time_zone_transition LIKE mysql.time_zone_transition;
12 CREATE TABLE time_zone_transition_type LIKE mysql.time_zone_transition_type;
13 CREATE TABLE time_zone_leap_second LIKE mysql.time_zone_leap_second;
14 ALTER TABLE time_zone_name ENGINE=MyISAM;
15 ALTER TABLE time_zone_transition_type ENGINE=MyISAM;
16 SET @save_wsrep_mode=@@WSREP_MODE;
17 #
18 # Run on zoneinfo directory --skip-write-binlog
19 #
20
21 # Apply on node_1
22
23 Warnings:
24 Warning 4200 The setting 'alter_algorithm' is ignored. It only exists for compatibility with old installations and will be removed in a future release
25 Warnings:
26 Warning 4200 The setting 'alter_algorithm' is ignored. It only exists for compatibility with old installations and will be removed in a future release
27 'binlog stationary as expected'
28 SELECT @wsrep_is_on, @wsrep_cannot_replicate_tz, @save_wsrep_on, @save_sql_log_bin, @@WSREP_ON, @@SQL_LOG_BIN;
29 @wsrep_is_on @wsrep_cannot_replicate_tz @save_wsrep_on @save_sql_log_bin @@WSREP_ON @@SQL_LOG_BIN
30 1 0 1 1 1 1
31 SELECT g.VARIABLE_NAME, g.VARIABLE_VALUE - b.VARIABLE_VALUE AS diff
32 FROM information_schema.global_status g
33 JOIN baseline b USING (VARIABLE_NAME)
34 ORDER BY g.VARIABLE_NAME;
35 VARIABLE_NAME diff
36 COM_ALTER_TABLE 2
37 COM_BEGIN 0
38 COM_INSERT 6
39 COM_LOCK_TABLES 1
40 COM_TRUNCATE 4
41 SELECT COUNT(*) FROM time_zone;
42 COUNT(*)
43 2
44 SELECT COUNT(*) FROM time_zone_name;
45 COUNT(*)
46 2
47 SELECT COUNT(*) FROM time_zone_transition;
48 COUNT(*)
49 0
50 SELECT COUNT(*) FROM time_zone_transition_type;
51 COUNT(*)
52 2
53 SELECT COUNT(*) FROM time_zone_leap_second;
54 COUNT(*)
55 0
56
57 # On node_2 (not replicated)
58
59 connection node_2;
60 SELECT COUNT(*) FROM time_zone;
61 COUNT(*)
62 0
63 SELECT COUNT(*) FROM time_zone_name;
64 COUNT(*)
65 0
66 SELECT COUNT(*) FROM time_zone_transition;
67 COUNT(*)
68 0
69 SELECT COUNT(*) FROM time_zone_transition_type;
70 COUNT(*)
71 0
72 SELECT COUNT(*) FROM time_zone_leap_second;
73 COUNT(*)
74 0
75
76 # Apply on node_1
77
78 connection node_1;
79 SET GLOBAL WSREP_MODE='REPLICATE_ARIA,REPLICATE_MYISAM';
80 Warnings:
81 Warning 4200 The setting 'alter_algorithm' is ignored. It only exists for compatibility with old installations and will be removed in a future release
82 Warnings:
83 Warning 4200 The setting 'alter_algorithm' is ignored. It only exists for compatibility with old installations and will be removed in a future release
84 'binlog stationary as expected'
85 SELECT @wsrep_is_on, @wsrep_cannot_replicate_tz, @save_wsrep_on, @save_sql_log_bin, @@WSREP_ON, @@SQL_LOG_BIN;
86 @wsrep_is_on @wsrep_cannot_replicate_tz @save_wsrep_on @save_sql_log_bin @@WSREP_ON @@SQL_LOG_BIN
87 1 0 1 1 1 1
88 SELECT g.VARIABLE_NAME, g.VARIABLE_VALUE - b.VARIABLE_VALUE AS diff
89 FROM information_schema.global_status g
90 JOIN baseline b USING (VARIABLE_NAME)
91 ORDER BY g.VARIABLE_NAME;
92 VARIABLE_NAME diff
93 COM_ALTER_TABLE 2
94 COM_BEGIN 0
95 COM_INSERT 6
96 COM_LOCK_TABLES 1
97 COM_TRUNCATE 4
98 SELECT COUNT(*) FROM time_zone;
99 COUNT(*)
100 2
101 SELECT COUNT(*) FROM time_zone_name;
102 COUNT(*)
103 2
104 SELECT COUNT(*) FROM time_zone_transition;
105 COUNT(*)
106 0
107 SELECT COUNT(*) FROM time_zone_transition_type;
108 COUNT(*)
109 2
110 SELECT COUNT(*) FROM time_zone_leap_second;
111 COUNT(*)
112 0
113
114 # On node_2 (not replicated)
115
116 connection node_2;
117 SELECT COUNT(*) FROM time_zone;
118 COUNT(*)
119 0
120 SELECT COUNT(*) FROM time_zone_name;
121 COUNT(*)
122 0
123 SELECT COUNT(*) FROM time_zone_transition;
124 COUNT(*)
125 0
126 SELECT COUNT(*) FROM time_zone_transition_type;
127 COUNT(*)
128 0
129 SELECT COUNT(*) FROM time_zone_leap_second;
130 COUNT(*)
131 0
132 #
133 # Run on zoneinfo directory without --skip-write-binlog
134 #
135
136 # Apply on node_1
137
138 connection node_1;
139 Warnings:
140 Warning 4200 The setting 'alter_algorithm' is ignored. It only exists for compatibility with old installations and will be removed in a future release
141 Warnings:
142 Warning 4200 The setting 'alter_algorithm' is ignored. It only exists for compatibility with old installations and will be removed in a future release
143 'binlog advanced as expected'
144 SELECT @wsrep_is_on, @wsrep_cannot_replicate_tz, @save_wsrep_on, @save_sql_log_bin, @@WSREP_ON, @@SQL_LOG_BIN;
145 @wsrep_is_on @wsrep_cannot_replicate_tz @save_wsrep_on @save_sql_log_bin @@WSREP_ON @@SQL_LOG_BIN
146 1 0 1 1 1 1
147 SELECT g.VARIABLE_NAME, g.VARIABLE_VALUE - b.VARIABLE_VALUE AS diff
148 FROM information_schema.global_status g
149 JOIN baseline b USING (VARIABLE_NAME)
150 ORDER BY g.VARIABLE_NAME;
151 VARIABLE_NAME diff
152 COM_ALTER_TABLE 2
153 COM_BEGIN 0
154 COM_INSERT 6
155 COM_LOCK_TABLES 1
156 COM_TRUNCATE 4
157 SELECT COUNT(*) FROM time_zone;
158 COUNT(*)
159 2
160 SELECT COUNT(*) FROM time_zone_name;
161 COUNT(*)
162 2
163 SELECT COUNT(*) FROM time_zone_transition;
164 COUNT(*)
165 0
166 SELECT COUNT(*) FROM time_zone_transition_type;
167 COUNT(*)
168 2
169 SELECT COUNT(*) FROM time_zone_leap_second;
170 COUNT(*)
171 0
172
173 # On node_2 (replicated via ARIA)
174
175 connection node_2;
176 SELECT COUNT(*) FROM time_zone;
177 COUNT(*)
178 2
179 SELECT COUNT(*) FROM time_zone_name;
180 COUNT(*)
181 0
182 SELECT COUNT(*) FROM time_zone_transition;
183 COUNT(*)
184 0
185 SELECT COUNT(*) FROM time_zone_transition_type;
186 COUNT(*)
187 0
188 SELECT COUNT(*) FROM time_zone_leap_second;
189 COUNT(*)
190 0
191 TRUNCATE TABLE time_zone;
192 TRUNCATE TABLE time_zone_name;
193 TRUNCATE TABLE time_zone_transition;
194 TRUNCATE TABLE time_zone_transition_type;
195 TRUNCATE TABLE time_zone_leap_second;
196
197 # Apply on node_1
198
199 connection node_1;
200 SET GLOBAL WSREP_MODE='';
201 Warnings:
202 Warning 4200 The setting 'alter_algorithm' is ignored. It only exists for compatibility with old installations and will be removed in a future release
203 Warnings:
204 Warning 4200 The setting 'alter_algorithm' is ignored. It only exists for compatibility with old installations and will be removed in a future release
205 'binlog advanced as expected'
206 SELECT @wsrep_is_on, @wsrep_cannot_replicate_tz, @save_wsrep_on, @save_sql_log_bin, @@WSREP_ON, @@SQL_LOG_BIN;
207 @wsrep_is_on @wsrep_cannot_replicate_tz @save_wsrep_on @save_sql_log_bin @@WSREP_ON @@SQL_LOG_BIN
208 1 1 1 1 1 1
209 SELECT g.VARIABLE_NAME, g.VARIABLE_VALUE - b.VARIABLE_VALUE AS diff
210 FROM information_schema.global_status g
211 JOIN baseline b USING (VARIABLE_NAME)
212 ORDER BY g.VARIABLE_NAME;
213 VARIABLE_NAME diff
214 COM_ALTER_TABLE 8
215 COM_BEGIN 1
216 COM_INSERT 6
217 COM_LOCK_TABLES 0
218 COM_TRUNCATE 4
219 SELECT COUNT(*) FROM time_zone;
220 COUNT(*)
221 2
222 SELECT COUNT(*) FROM time_zone_name;
223 COUNT(*)
224 2
225 SELECT COUNT(*) FROM time_zone_transition;
226 COUNT(*)
227 0
228 SELECT COUNT(*) FROM time_zone_transition_type;
229 COUNT(*)
230 2
231 SELECT COUNT(*) FROM time_zone_leap_second;
232 COUNT(*)
233 0
234 SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES
235 WHERE
236 TABLE_SCHEMA = DATABASE()
237 AND TABLE_NAME LIKE 'time_zone%' ORDER BY TABLE_NAME;
238 TABLE_NAME ENGINE
239 time_zone Aria
240 time_zone_leap_second Aria
241 time_zone_name MyISAM
242 time_zone_transition Aria
243 time_zone_transition_type MyISAM
244
245 # On node_2 (replicated via InnoDB)
246
247 connection node_2;
248 SELECT COUNT(*) FROM time_zone;
249 COUNT(*)
250 2
251 SELECT COUNT(*) FROM time_zone_name;
252 COUNT(*)
253 2
254 SELECT COUNT(*) FROM time_zone_transition;
255 COUNT(*)
256 0
257 SELECT COUNT(*) FROM time_zone_transition_type;
258 COUNT(*)
259 2
260 SELECT COUNT(*) FROM time_zone_leap_second;
261 COUNT(*)
262 0
263 connection node_1;
264 SET GLOBAL WSREP_MODE=@save_wsrep_mode;
265 DROP TABLE baseline;
266 DROP TABLE time_zone;
267 DROP TABLE time_zone_name;
268 DROP TABLE time_zone_transition;
269 DROP TABLE time_zone_transition_type;
270 DROP TABLE time_zone_leap_second;
271 #
272 # End of 10.6 tests
273 #