Bug #115021 Contribution: mysql_tzinfo_to_sql: suppress expected warnings
Submitted: 15 May 2024 21:29 Modified: 28 Jul 15:23
Reporter: OCA Admin (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[15 May 2024 21:29] OCA Admin 
Description:
This bug tracks a contribution by Daniël van Eeden (Github user: dveeden), as described in http://github.com/mysql/mysql-server/pull/542

How to repeat:
See description

Suggested fix:
See contribution code attached
[15 May 2024 21:29] OCA Admin 
Contribution submitted via Github - mysql_tzinfo_to_sql: suppress expected warnings 
(*) Contribution by Daniël van Eeden (Github dveeden, mysql-server/pull/542#issuecomment-2113459232): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_1871819431.txt (text/plain), 2.67 KiB.
[16 May 2024 5:55] MySQL Verification Team 
Hello Daniël,

Thank you for the report and contribution.

regards,
Umesh
[28 May 1:13] MySQL Admin 
Posted by developer: Bug status updated to 'Documenting'
[28 Jul 15:23] Edward Gilmore 
Posted by developer:
 
Added the following note to the MySQL Server 8.4.11, 9.7.2, and 26.7.0 release notes:

mysql_tzinfo_to_sql generated unnecessary warnings. For example:

Warning: Unable to load '/usr/share/zoneinfo//iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo//leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo//leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo//tzdata.zi' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo//zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo//zone1970.tab' as time zone. Skipping it.

As of this release, those warnings are suppressed.
Our thanks to Daniël van Eeden for the contribution.