MySQL Bugs: #84116: New Time Zone at America/Caracas

Bug #84116	New Time Zone at America/Caracas
Submitted:	8 Dec 2016 14:30	Modified:	12 Jan 2017 14:18
Reporter:	Nelson Belfort	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.5	OS:	Windows
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	time zone caracas

Description:
On May 1st 2016, 2:30AM  Venezuela (americas/caracas) change its time zone, from UTM -4:30 to -4:00, that is not incorporated on the:

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

(Not at the timezone_2016j_posix.zip file)

How to repeat:

select convert_tz('2016-05-01 2:29:00','-4:30','America/Caracas')
response: 2016-05-01 02:29:00

select convert_tz('2016-05-01 2:30:00','-4:30','America/Caracas')
right answer: 2016-05-01 03:00:00

Suggested fix:
Just add a registry at the table "time_zone_transition" with the new transition:

1)
INSERT INTO `time_zone_transition` (`Time_zone_id`, `Transition_time`, `Transition_type_id`) VALUES (90, 1462086000, 2);

2)
Restart server

Thank you for the report.

The tables in "timezone_2016j_posix.zip" are genereted from the official
IANA time zone tables found at http://www.iana.org/time-zones. The
change in time zone info for Venezuela (americas/caracas) is included
in the IANA data files
  
  # Zone  NAME            GMTOFF  RULES   FORMAT  [UNTIL]
  Zone    America/Caracas -4:27:44 -      LMT     1890
                          -4:27:40 -      CMT     1912 Feb 12 # Caracas Mean Time?
                          -4:30   -       VET     1965 Jan  1  0:00 # Venezuela T.
                          -4:00   -       VET     2007 Dec  9  3:00
                          -4:30   -       VET     2016 May  1  2:30
                          -4:00   -       VET

The output of convert_tz() is as described in this bug report, could
you please clarify why you consider this to be a bug?

  convert_tz('2016-05-01 2:29:00','-4:30','America/Caracas')
  2016-05-01 02:29:00

  convert_tz('2016-05-01 2:30:00','-4:30','America/Caracas')
  2016-05-01 03:00:00

  convert_tz('2016-05-01 3:00:00','-4:00','America/Caracas')
  2016-05-01 03:00:00

The first two arguments to convert_tz() indicate that you view the
output from the point of the old time zone info. The first run
naturally then show the same input and output time.

The second run is also viewing the time from the point of view from
the old time zone setting, and then the local time has moved forward
30 minutes, i.e. moved to 03:00:00. Exactly as graphically illustrated
here

  http://www.timeanddate.com/time/change/venezuela/caracas

Could you please clarify what different output you expected and why?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".