/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:
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 ...