Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.5.37, 10.0.10
-
Component/s: Scripts & Clients
-
Labels:
-
Environment:Linux
-
Sprint:5.5.44
Description
/usr/share/zoneinfo may contain some files where a warning like
Local time zone must be set--see zic manual page
may be given instead of a time zone abbreviation for time_zone_transition_type.
This leads to output like:
INSERT INTO time_zone (Use_leap_seconds) VALUES ('N');
SET @time_zone_id= LAST_INSERT_ID();
INSERT INTO time_zone_name (Name, Time_zone_id) VALUES ('Factory', @time_zone_id);
INSERT INTO time_zone_transition_type (Time_zone_id, Transition_type_id, Offset, Is_DST, Abbreviation) VALUES
(@time_zone_id, 0, 0, 0, 'Local time zone must be set--see zic manual page')
;
which will fail if sql_mode=STRICT_ALL_TABLES is set as the "Local time zone ..." string is much longer than the 8 characters reserved for "Abbreviation" in the time_zone_transition_type table
Suggestion: filter out these time zones completely and don't get INSERT statements for them at all as they contain no useful information anyway ...
Gliffy Diagrams
Attachments
Issue Links
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Fixed in MySQL 5.7.5
Sergei Golubchik, please review fix for this bug.
proposed patch to ignore invalid entries