Bug #74716 Time Zone Description Tables are severely outdated

Submitted: 6 Nov 2014 17:53 Modified: 1 Jul 2015 6:59
Reporter: Matt Johnson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version: 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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.058 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.