Bug #74716 Time Zone Description Tables are severely outdated

• Submitted: 6 Nov 2014 17:53
• Modified: 1 Jul 2015 6:59
• Reporter: Matt Johnson
• Status: Closed
• Category: MySQL Server: DML
• Severity: S3 (Non-critical)
• OS: Any
• Assigned to: Georgi Kodinov
• CPU Architecture: Any
• Tags: Download, time zone, timezone

[6 Nov 2014 17:53] Matt Johnson

Description:
Per the documentation, to update the MySQL time zone data on systems that do not have their own zoneinfo data (such as Windows) requires downloading and installing the Time Zone Description tables from here:
http://dev.mysql.com/downloads/timezones.html

However, the last version available on this page is 2011n.

How to repeat:
Look at the version number on http://dev.mysql.com/downloads/timezones.html

Look at the current version number on http://www.iana.org/time-zones

Suggested fix:
It is very important that time zone data can be updated.  This pages should be continuously updated with data from the IANA time zone database:
http://www.iana.org/time-zones

The current version (as of reporting this bug) is 2014i.

A MySQL maintainer should be subscribed to the announcements list to receive notification of new releases. A corresponding update should be published within a reasonable timeframe.

If this is already happening somewhere, it is not reflected on the website or in the documentation.

[6 Nov 2014 23:33] MySQL Verification Team

Thank you for the bug report.

[4 Feb 2015 13:17] Matthias Maier

Will there be an update of the time zone description tables in the near future?

[11 Mar 2015 4:04] Praveenkumar Hulakund

Time zone description tables are updated now.

Packages of the same can be downloaded from the link,

http://dev.mysql.com/downloads/timezones.html

[24 Jun 2015 19:03] Matt Johnson

Current tzdb version is now 2015e, but only 2015a is available on the mysql site.

As mentioned in the original issue, it's important that a MySQL maintainer is subscribed to the IANA time zone announcements list to receive notification of new releases. A corresponding update should be published within a reasonable timeframe.

This needs to be a regular process.  Otherwise, it will continue to grow stale as new time zone updates are released often.

Announcements Mailing List:
https://mm.icann.org/mailman/listinfo/tz-announce

[1 Jul 2015 10:34] MySQL Verification Team

For update of this bug please follow http://bugs.mysql.com/bug.php?id=77576. Thanks.