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'

        Smart Checklist

          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