Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.5.19
-
None
-
None
-
Mageia Linux
Description
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 |