Debian Codegraph @

mysql-test/suite/galera/t/mariadb_tzinfo_to_sql.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/no_protocol.inc
4
5 --echo #
6 --echo # MDEV-28263: mariadb-tzinfo-to-sql improve wsrep and binlog cases
7 --echo #
8
9 --exec rm -rf $MYSQLTEST_VARDIR/zoneinfo
10 --exec mkdir $MYSQLTEST_VARDIR/zoneinfo
11 --exec ln -s $MYSQLTEST_VARDIR/zoneinfo $MYSQLTEST_VARDIR/zoneinfo/posix
12 --copy_file std_data/zoneinfo/GMT $MYSQLTEST_VARDIR/zoneinfo/GMT
13
14 --echo
15 --echo # On node_1
16 --connection node_1
17
18 CREATE TABLE time_zone LIKE mysql.time_zone;
19 CREATE TABLE time_zone_name LIKE mysql.time_zone_name;
20 CREATE TABLE time_zone_transition LIKE mysql.time_zone_transition;
21 CREATE TABLE time_zone_transition_type LIKE mysql.time_zone_transition_type;
22 CREATE TABLE time_zone_leap_second LIKE mysql.time_zone_leap_second;
23 ALTER TABLE time_zone_name ENGINE=MyISAM;
24 ALTER TABLE time_zone_transition_type ENGINE=MyISAM;
25
26 SET @save_wsrep_mode=@@WSREP_MODE;
27
28 --echo #
29 --echo # Run on zoneinfo directory --skip-write-binlog
30 --echo #
31
32 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
33 --exec $MYSQL_TZINFO_TO_SQL --skip-write-binlog $MYSQLTEST_VARDIR/zoneinfo 2>/dev/null > $MYSQL_TMP_DIR/tz.sql
34
35 --echo
36 --echo # Apply on node_1
37 --echo
38 --let $snap_pos= query_get_value(SHOW STATUS LIKE 'binlog_snapshot_position', Value, 1)
39 --disable_query_log
40 CREATE TEMPORARY TABLE baseline AS
41 SELECT VARIABLE_NAME,VARIABLE_VALUE
42 FROM information_schema.global_status
43 WHERE VARIABLE_NAME IN ('COM_BEGIN', 'COM_INSERT', 'COM_LOCK_TABLES', 'COM_ALTER_TABLE', 'COM_TRUNCATE');
44 --source $MYSQL_TMP_DIR/tz.sql
45 --enable_query_log
46 --let $new_snap_pos= query_get_value(SHOW STATUS LIKE 'binlog_snapshot_position', Value, 1)
47
48 if ($snap_pos == $new_snap_pos)
49 {
50 --echo 'binlog stationary as expected'
51 }
52 SELECT @wsrep_is_on, @wsrep_cannot_replicate_tz, @save_wsrep_on, @save_sql_log_bin, @@WSREP_ON, @@SQL_LOG_BIN;
53 SELECT g.VARIABLE_NAME, g.VARIABLE_VALUE - b.VARIABLE_VALUE AS diff
54 FROM information_schema.global_status g
55 JOIN baseline b USING (VARIABLE_NAME)
56 ORDER BY g.VARIABLE_NAME;
57
58 SELECT COUNT(*) FROM time_zone;
59 SELECT COUNT(*) FROM time_zone_name;
60 SELECT COUNT(*) FROM time_zone_transition;
61 SELECT COUNT(*) FROM time_zone_transition_type;
62 SELECT COUNT(*) FROM time_zone_leap_second;
63
64 --echo
65 --echo # On node_2 (not replicated)
66 --echo
67 --connection node_2
68
69 SELECT COUNT(*) FROM time_zone;
70 SELECT COUNT(*) FROM time_zone_name;
71 SELECT COUNT(*) FROM time_zone_transition;
72 SELECT COUNT(*) FROM time_zone_transition_type;
73 SELECT COUNT(*) FROM time_zone_leap_second;
74
75 --echo
76 --echo # Apply on node_1
77 --echo
78 --connection node_1
79
80 SET GLOBAL WSREP_MODE='REPLICATE_ARIA,REPLICATE_MYISAM';
81 --disable_query_log
82 CREATE OR REPLACE TEMPORARY TABLE baseline AS
83 SELECT VARIABLE_NAME,VARIABLE_VALUE
84 FROM information_schema.global_status
85 WHERE VARIABLE_NAME IN ('COM_BEGIN', 'COM_INSERT', 'COM_LOCK_TABLES', 'COM_ALTER_TABLE', 'COM_TRUNCATE');
86 --source $MYSQL_TMP_DIR/tz.sql
87 --enable_query_log
88 --let $new_snap_pos= query_get_value(SHOW STATUS LIKE 'binlog_snapshot_position', Value, 1)
89
90 if ($snap_pos == $new_snap_pos)
91 {
92 --echo 'binlog stationary as expected'
93 }
94 SELECT @wsrep_is_on, @wsrep_cannot_replicate_tz, @save_wsrep_on, @save_sql_log_bin, @@WSREP_ON, @@SQL_LOG_BIN;
95 SELECT g.VARIABLE_NAME, g.VARIABLE_VALUE - b.VARIABLE_VALUE AS diff
96 FROM information_schema.global_status g
97 JOIN baseline b USING (VARIABLE_NAME)
98 ORDER BY g.VARIABLE_NAME;
99
100 SELECT COUNT(*) FROM time_zone;
101 SELECT COUNT(*) FROM time_zone_name;
102 SELECT COUNT(*) FROM time_zone_transition;
103 SELECT COUNT(*) FROM time_zone_transition_type;
104 SELECT COUNT(*) FROM time_zone_leap_second;
105
106 --echo
107 --echo # On node_2 (not replicated)
108 --echo
109 --connection node_2
110
111 SELECT COUNT(*) FROM time_zone;
112 SELECT COUNT(*) FROM time_zone_name;
113 SELECT COUNT(*) FROM time_zone_transition;
114 SELECT COUNT(*) FROM time_zone_transition_type;
115 SELECT COUNT(*) FROM time_zone_leap_second;
116
117 --echo #
118 --echo # Run on zoneinfo directory without --skip-write-binlog
119 --echo #
120
121 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
122 --exec $MYSQL_TZINFO_TO_SQL $MYSQLTEST_VARDIR/zoneinfo 2>/dev/null > $MYSQL_TMP_DIR/tz.sql
123
124 --echo
125 --echo # Apply on node_1
126 --echo
127 --connection node_1
128
129 --disable_query_log
130 CREATE OR REPLACE TEMPORARY TABLE baseline AS
131 SELECT VARIABLE_NAME,VARIABLE_VALUE
132 FROM information_schema.global_status
133 WHERE VARIABLE_NAME IN ('COM_BEGIN', 'COM_INSERT', 'COM_LOCK_TABLES', 'COM_ALTER_TABLE', 'COM_TRUNCATE');
134 --source $MYSQL_TMP_DIR/tz.sql
135 --enable_query_log
136 --let $new_snap_pos= query_get_value(SHOW STATUS LIKE 'binlog_snapshot_position', Value, 1)
137
138 if ($snap_pos < $new_snap_pos)
139 {
140 --echo 'binlog advanced as expected'
141 }
142 SELECT @wsrep_is_on, @wsrep_cannot_replicate_tz, @save_wsrep_on, @save_sql_log_bin, @@WSREP_ON, @@SQL_LOG_BIN;
143 SELECT g.VARIABLE_NAME, g.VARIABLE_VALUE - b.VARIABLE_VALUE AS diff
144 FROM information_schema.global_status g
145 JOIN baseline b USING (VARIABLE_NAME)
146 ORDER BY g.VARIABLE_NAME;
147
148 SELECT COUNT(*) FROM time_zone;
149 SELECT COUNT(*) FROM time_zone_name;
150 SELECT COUNT(*) FROM time_zone_transition;
151 SELECT COUNT(*) FROM time_zone_transition_type;
152 SELECT COUNT(*) FROM time_zone_leap_second;
153
154 --echo
155 --echo # On node_2 (replicated via ARIA)
156 --echo
157 --connection node_2
158
159 SELECT COUNT(*) FROM time_zone;
160 SELECT COUNT(*) FROM time_zone_name;
161 SELECT COUNT(*) FROM time_zone_transition;
162 SELECT COUNT(*) FROM time_zone_transition_type;
163 SELECT COUNT(*) FROM time_zone_leap_second;
164
165 TRUNCATE TABLE time_zone;
166 TRUNCATE TABLE time_zone_name;
167 TRUNCATE TABLE time_zone_transition;
168 TRUNCATE TABLE time_zone_transition_type;
169 TRUNCATE TABLE time_zone_leap_second;
170
171 --echo
172 --echo # Apply on node_1
173 --echo
174 --connection node_1
175
176 SET GLOBAL WSREP_MODE='';
177 --let $snap_pos= query_get_value(SHOW STATUS LIKE 'binlog_snapshot_position', Value, 1)
178 --disable_query_log
179 CREATE OR REPLACE TEMPORARY TABLE baseline AS
180 SELECT VARIABLE_NAME,VARIABLE_VALUE
181 FROM information_schema.global_status
182 WHERE VARIABLE_NAME IN ('COM_BEGIN', 'COM_INSERT', 'COM_LOCK_TABLES', 'COM_ALTER_TABLE', 'COM_TRUNCATE');
183 --source $MYSQL_TMP_DIR/tz.sql
184 --enable_query_log
185 --let $new_snap_pos= query_get_value(SHOW STATUS LIKE 'binlog_snapshot_position', Value, 1)
186
187 if ($snap_pos < $new_snap_pos)
188 {
189 --echo 'binlog advanced as expected'
190 }
191 SELECT @wsrep_is_on, @wsrep_cannot_replicate_tz, @save_wsrep_on, @save_sql_log_bin, @@WSREP_ON, @@SQL_LOG_BIN;
192 SELECT g.VARIABLE_NAME, g.VARIABLE_VALUE - b.VARIABLE_VALUE AS diff
193 FROM information_schema.global_status g
194 JOIN baseline b USING (VARIABLE_NAME)
195 ORDER BY g.VARIABLE_NAME;
196
197 SELECT COUNT(*) FROM time_zone;
198 SELECT COUNT(*) FROM time_zone_name;
199 SELECT COUNT(*) FROM time_zone_transition;
200 SELECT COUNT(*) FROM time_zone_transition_type;
201 SELECT COUNT(*) FROM time_zone_leap_second;
202
203 SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES
204 WHERE
205 TABLE_SCHEMA = DATABASE()
206 AND TABLE_NAME LIKE 'time_zone%' ORDER BY TABLE_NAME;
207
208 --echo
209 --echo # On node_2 (replicated via InnoDB)
210 --echo
211 --connection node_2
212
213 SELECT COUNT(*) FROM time_zone;
214 SELECT COUNT(*) FROM time_zone_name;
215 SELECT COUNT(*) FROM time_zone_transition;
216 SELECT COUNT(*) FROM time_zone_transition_type;
217 SELECT COUNT(*) FROM time_zone_leap_second;
218
219 #
220 # Cleanup
221 #
222
223 --connection node_1
224 --remove_file $MYSQL_TMP_DIR/tz.sql
225 --exec rm -rf $MYSQLTEST_VARDIR/zoneinfo
226 SET GLOBAL WSREP_MODE=@save_wsrep_mode;
227 DROP TABLE baseline;
228 DROP TABLE time_zone;
229 DROP TABLE time_zone_name;
230 DROP TABLE time_zone_transition;
231 DROP TABLE time_zone_transition_type;
232 DROP TABLE time_zone_leap_second;
233
234 --echo #
235 --echo # End of 10.6 tests
236 --echo #