Debian Codegraph @

mysql-test/suite/galera/r/mysql_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 #
15 # Run on zoneinfo directory --skip-write-binlog
16 #
17
18 # Apply on node_1
19
20 load timezones
21 'binlog stationary as expected'
22 SELECT COUNT(*) FROM time_zone;
23 COUNT(*)
24 2
25 SELECT COUNT(*) FROM time_zone_name;
26 COUNT(*)
27 2
28 SELECT COUNT(*) FROM time_zone_transition;
29 COUNT(*)
30 0
31 SELECT COUNT(*) FROM time_zone_transition_type;
32 COUNT(*)
33 2
34 SELECT COUNT(*) FROM time_zone_leap_second;
35 COUNT(*)
36 0
37
38 # On node_2 (not replicated)
39
40 connection node_2;
41 SELECT COUNT(*) FROM time_zone;
42 COUNT(*)
43 0
44 SELECT COUNT(*) FROM time_zone_name;
45 COUNT(*)
46 0
47 SELECT COUNT(*) FROM time_zone_transition;
48 COUNT(*)
49 0
50 SELECT COUNT(*) FROM time_zone_transition_type;
51 COUNT(*)
52 0
53 SELECT COUNT(*) FROM time_zone_leap_second;
54 COUNT(*)
55 0
56 #
57 # Run on zoneinfo directory without --skip-write-binlog
58 #
59
60 # Apply on node_1
61
62 connection node_1;
63 load timezones
64 'binlog advanced as expected'
65 SELECT COUNT(*) FROM time_zone;
66 COUNT(*)
67 2
68 SELECT COUNT(*) FROM time_zone_name;
69 COUNT(*)
70 2
71 SELECT COUNT(*) FROM time_zone_transition;
72 COUNT(*)
73 0
74 SELECT COUNT(*) FROM time_zone_transition_type;
75 COUNT(*)
76 2
77 SELECT COUNT(*) FROM time_zone_leap_second;
78 COUNT(*)
79 0
80
81 # On node_2 (replicated via InnoDB)
82
83 connection node_2;
84 SELECT COUNT(*) FROM time_zone;
85 COUNT(*)
86 2
87 SELECT COUNT(*) FROM time_zone_name;
88 COUNT(*)
89 2
90 SELECT COUNT(*) FROM time_zone_transition;
91 COUNT(*)
92 0
93 SELECT COUNT(*) FROM time_zone_transition_type;
94 COUNT(*)
95 2
96 SELECT COUNT(*) FROM time_zone_leap_second;
97 COUNT(*)
98 0
99 TRUNCATE TABLE time_zone;
100 TRUNCATE TABLE time_zone_name;
101 TRUNCATE TABLE time_zone_transition;
102 TRUNCATE TABLE time_zone_transition_type;
103 TRUNCATE TABLE time_zone_leap_second;
104
105 # Apply on node_1 (with wsrep_on=OFF)
106
107 connection node_1;
108 SET GLOBAL WSREP_ON=OFF;
109 load timezones
110 SET GLOBAL WSREP_ON=ON;
111 'binlog advanced as expected'
112 SELECT COUNT(*) FROM time_zone;
113 COUNT(*)
114 2
115 SELECT COUNT(*) FROM time_zone_name;
116 COUNT(*)
117 2
118 SELECT COUNT(*) FROM time_zone_transition;
119 COUNT(*)
120 0
121 SELECT COUNT(*) FROM time_zone_transition_type;
122 COUNT(*)
123 2
124 SELECT COUNT(*) FROM time_zone_leap_second;
125 COUNT(*)
126 0
127
128 # On node_2 (Should not have been replicated)
129
130 connection node_2;
131 SELECT COUNT(*) FROM time_zone;
132 COUNT(*)
133 0
134 SELECT COUNT(*) FROM time_zone_name;
135 COUNT(*)
136 0
137 SELECT COUNT(*) FROM time_zone_transition;
138 COUNT(*)
139 0
140 SELECT COUNT(*) FROM time_zone_transition_type;
141 COUNT(*)
142 0
143 SELECT COUNT(*) FROM time_zone_leap_second;
144 COUNT(*)
145 0
146 connection node_1;
147 DROP TABLE time_zone;
148 DROP TABLE time_zone_name;
149 DROP TABLE time_zone_transition;
150 DROP TABLE time_zone_transition_type;
151 DROP TABLE time_zone_leap_second;
152 #
153 # End of 10.2 tests
154 #