Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-6899

Correct main.events_bugs and main.events_1 to interpret date 01-01-2020 properly

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 8.0.18-9, 5.6.47-87.0, 5.7.29-32
    • Fix Version/s: 8.0.19-10, 5.6.48-88.0, 5.7.30-33
    • Component/s: None
    • Labels:

      Description

      Both main.events_bugs and main.events_1 fail with the following errors

      mysqltest: At line 69: Query 'ALTER EVENT event_starts_test ON SCHEDULE AT '2020-02-02 20:00:02'' failed.
ERROR 1589 (HY000): Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was not changed. Specify a time in the future.

      mysqltest: At line 1036: Query 'CREATE EVENT e1 ON SCHEDULE AT '2020-01-01 00:00:00' DO SET @a = 1' succeeded, should have failed with error '1290'

        Attachments

          Activity

            People

            Assignee:
            yura.sorokin Yura Sorokin
            Reporter:
            yura.sorokin Yura Sorokin
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 5 hours, 30 minutes
                5h 30m

                  Smart Checklist