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

Timestamp is not set to CURRENT_TIMESTAMP in grant tables

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 8.0.x, Not 5.6.x, Not 5.7.x
    • 8.0.23-14 (Q1 2021)
    • None
    • None

    Description

      Steps to reproduce:

      Run any failing test specified below.

      Result:

      The following tests are failing with error: Incorrect datetime value: '0000-00-00 00:00:00' for column 'Timestamp'

      main.system_tables_myisam
      binlog.binlog_stm_unsafe_read_acl_tables_in_dml_ddl
      main.system_tables_myisam_lctn_1
      main.mysql_upgrade_grant
      main.ps_sys_upgrade
      sysschema.mysqldump
      main.transactional_acl_tables
      main.schema_read_only_cs

       

      Expected result:

      Tests should pass

      Attachments

        Issue Links

          Activity

            People

              venkatesh.prasad Venkatesh Prasad
              kamil.holubicki Kamil Holubicki
              Votes:
              0 Vote for this issue
              Watchers:
              2 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 - 1 week, 1 day, 5 hours, 30 minutes
                  1w 1d 5h 30m

                  Smart Checklist