Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17988

mysql_upgrade failed to revert innodb_index/table_stats tables column datatype length

    Details

      Description

      table_name field in both tables (innodb_table_stats & innodb_index_stats) are increased to 199 from 64 for VARCHAR in 10.2.17
      However, downgrading it back to 10.2.15 didn't changed VARCHAR(199) to VARCHAR(64)

      $ mysql_upgrade --upgrade-system-tables
       
      The --upgrade-system-tables option was used, user tables won't be touched.
       
      Phase 1/7: Checking and upgrading mysql database
      Processing databases
       
      mysql
      .
      mysql.innodb_index_stats OK
      mysql.innodb_table_stats OK
      .
      Phase 7/7: Running 'FLUSH PRIVILEGES'
      OK
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                muhammad.irfan Muhammad Irfan
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: