Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/not_embedded.inc
4 # merge note: 10.6 change not_embedded.inc to no_protocol.inc
5
6 # Unlike the similar galera.mariadb_tzinfo_to_sql.test in 10.6+, this
7 # tests that the output can be parsed by the mysql client.
8 --echo #
9 --echo # MDEV-28263: mariadb-tzinfo-to-sql improve wsrep and binlog cases
10 --echo #
11
12 --exec rm -rf $MYSQLTEST_VARDIR/zoneinfo
13 --exec mkdir $MYSQLTEST_VARDIR/zoneinfo
14 --exec ln -s $MYSQLTEST_VARDIR/zoneinfo $MYSQLTEST_VARDIR/zoneinfo/posix
15 --copy_file std_data/zoneinfo/GMT $MYSQLTEST_VARDIR/zoneinfo/GMT
16
17 --echo
18 --echo # On node_1
19 --connection node_1
20
21 CREATE TABLE time_zone LIKE mysql.time_zone;
22 CREATE TABLE time_zone_name LIKE mysql.time_zone_name;
23 CREATE TABLE time_zone_transition LIKE mysql.time_zone_transition;
24 CREATE TABLE time_zone_transition_type LIKE mysql.time_zone_transition_type;
25 CREATE TABLE time_zone_leap_second LIKE mysql.time_zone_leap_second;
26
27 --echo #
28 --echo # Run on zoneinfo directory --skip-write-binlog
29 --echo #
30
31 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
32 --exec $MYSQL_TZINFO_TO_SQL --skip-write-binlog $MYSQLTEST_VARDIR/zoneinfo 2>/dev/null > $MYSQL_TMP_DIR/tz.sql
33
34 --echo
35 --echo # Apply on node_1
36 --echo
37 --let $snap_pos= query_get_value(SHOW STATUS LIKE 'binlog_snapshot_position', Value, 1)
38 --echo load timezones
39 --exec $MYSQL test < "$MYSQL_TMP_DIR/tz.sql"
40 --let $new_snap_pos= query_get_value(SHOW STATUS LIKE 'binlog_snapshot_position', Value, 1)
41
42 if ($snap_pos == $new_snap_pos)
43 {
44 --echo 'binlog stationary as expected'
45 }
46
47 SELECT COUNT(*) FROM time_zone;
48 SELECT COUNT(*) FROM time_zone_name;
49 SELECT COUNT(*) FROM time_zone_transition;
50 SELECT COUNT(*) FROM time_zone_transition_type;
51 SELECT COUNT(*) FROM time_zone_leap_second;
52
53 --echo
54 --echo # On node_2 (not replicated)
55 --echo
56 --connection node_2
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 # Run on zoneinfo directory without --skip-write-binlog
66 --echo #
67
68 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
69 --exec $MYSQL_TZINFO_TO_SQL $MYSQLTEST_VARDIR/zoneinfo 2>/dev/null > $MYSQL_TMP_DIR/tz.sql
70
71 --echo
72 --echo # Apply on node_1
73 --echo
74 --connection node_1
75
76 --echo load timezones
77 --exec $MYSQL test < "$MYSQL_TMP_DIR/tz.sql"
78 --let $new_snap_pos= query_get_value(SHOW STATUS LIKE 'binlog_snapshot_position', Value, 1)
79
80 if ($snap_pos < $new_snap_pos)
81 {
82 --echo 'binlog advanced as expected'
83 }
84
85 SELECT COUNT(*) FROM time_zone;
86 SELECT COUNT(*) FROM time_zone_name;
87 SELECT COUNT(*) FROM time_zone_transition;
88 SELECT COUNT(*) FROM time_zone_transition_type;
89 SELECT COUNT(*) FROM time_zone_leap_second;
90
91 --echo
92 --echo # On node_2 (replicated via InnoDB)
93 --echo
94 --connection node_2
95
96 SELECT COUNT(*) FROM time_zone;
97 SELECT COUNT(*) FROM time_zone_name;
98 SELECT COUNT(*) FROM time_zone_transition;
99 SELECT COUNT(*) FROM time_zone_transition_type;
100 SELECT COUNT(*) FROM time_zone_leap_second;
101
102 TRUNCATE TABLE time_zone;
103 TRUNCATE TABLE time_zone_name;
104 TRUNCATE TABLE time_zone_transition;
105 TRUNCATE TABLE time_zone_transition_type;
106 TRUNCATE TABLE time_zone_leap_second;
107
108 --echo
109 --echo # Apply on node_1 (with wsrep_on=OFF)
110 --echo
111 --connection node_1
112
113 SET GLOBAL WSREP_ON=OFF;
114 --let $snap_pos= $new_snap_pos
115 --echo load timezones
116 --exec $MYSQL test < "$MYSQL_TMP_DIR/tz.sql"
117 --let $new_snap_pos= query_get_value(SHOW STATUS LIKE 'binlog_snapshot_position', Value, 1)
118 SET GLOBAL WSREP_ON=ON;
119
120 if ($snap_pos < $new_snap_pos)
121 {
122 --echo 'binlog advanced as expected'
123 }
124
125 SELECT COUNT(*) FROM time_zone;
126 SELECT COUNT(*) FROM time_zone_name;
127 SELECT COUNT(*) FROM time_zone_transition;
128 SELECT COUNT(*) FROM time_zone_transition_type;
129 SELECT COUNT(*) FROM time_zone_leap_second;
130
131 --echo
132 --echo # On node_2 (Should not have been replicated)
133 --echo
134 --connection node_2
135
136 SELECT COUNT(*) FROM time_zone;
137 SELECT COUNT(*) FROM time_zone_name;
138 SELECT COUNT(*) FROM time_zone_transition;
139 SELECT COUNT(*) FROM time_zone_transition_type;
140 SELECT COUNT(*) FROM time_zone_leap_second;
141
142 #
143 # Cleanup
144 #
145
146 --connection node_1
147 --remove_file $MYSQL_TMP_DIR/tz.sql
148 --exec rm -rf $MYSQLTEST_VARDIR/zoneinfo
149 DROP TABLE time_zone;
150 DROP TABLE time_zone_name;
151 DROP TABLE time_zone_transition;
152 DROP TABLE time_zone_transition_type;
153 DROP TABLE time_zone_leap_second;
154
155 --echo #
156 --echo # End of 10.2 tests
157 --echo #