• kroki/tomash@moonlight.home's avatar
    BUG#16420: Events: timestamps become UTC · 6d8f6b5b
    kroki/tomash@moonlight.home authored
    BUG#26429: SHOW CREATE EVENT is incorrect for an event that
               STARTS NOW()
    BUG#26431: Impossible to re-create an event from backup if its
               STARTS clause is in the past
    WL#3698: Events: execution in local time zone
    
    The problem was that local times specified by the user in AT, STARTS
    and ENDS of CREATE EVENT/ALTER EVENT statement were converted to UTC,
    and the original time zone was forgotten.  This way, event scheduler
    couldn't honor Daylight Saving Time shifts, and times shown to the
    user were also in UTC.  Additionally, CREATE EVENT didn't allow times
    in the past, thus preventing straightforward event restoration from
    old backups.
    
    This patch reworks event scheduler time computations, performing them
    in the time zone associated with the event.  Also it allows times to
    be in the past.
    
    The patch adds time_zone column to mysql.event table.
    
    NOTE: The patch is almost final, but the bug#9953 should be pushed
    first.
    6d8f6b5b
system_mysql_db.result 14 KB