|
Table time_zone_transition_type wrong after import in version 10.5.19:
mysql_tzinfo_to_sql /usr/share/zoneinfo|mysql mysql
|
select * from mysql.time_zone_transition_type LIMIT 10;
|
| Time_zone_id |
Transition_type_id |
Offset |
Is_DST |
Abbreviation |
| 1 |
0 |
0 |
0 |
|
| 2 |
0 |
0 |
0 |
|
| 3 |
0 |
0 |
0 |
|
| 4 |
0 |
0 |
0 |
|
| 5 |
0 |
0 |
0 |
|
| 6 |
0 |
0 |
0 |
|
| 7 |
0 |
0 |
0 |
|
| 8 |
0 |
0 |
0 |
|
| 9 |
0 |
0 |
0 |
|
| 10 |
0 |
0 |
0 |
|
The same on version 10.11.2:
select * from time_zone_transition_type LIMIT 10;
|
| Time_zone_id |
Transition_type_id |
Offset |
Is_DST |
Abbreviation |
| 1 |
0 |
-968 |
0 |
LMT |
| 1 |
1 |
0 |
0 |
GMT |
| 2 |
0 |
-968 |
0 |
LMT |
| 2 |
1 |
0 |
0 |
GMT |
| 3 |
0 |
8836 |
0 |
LMT |
| 3 |
1 |
9000 |
0 |
+0230 |
| 3 |
2 |
10800 |
0 |
EAT |
| 3 |
3 |
9900 |
0 |
+0245 |
| 3 |
4 |
10800 |
0 |
EAT |
| 4 |
0 |
732 |
0 |
LMT |
|