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

[PATCH] mysql_upgrade breaks databases with long user names

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.37, 10.0.10
    • 5.5.38, 10.0.11
    • None
    • None

    Description

      mysql_upgrade is supposed to be a no-op on databases that are fully upgraded already. But scripts/mysql_system_tables_fix.sql has lots of old statements including those that try to modify User column in different tables to be char(16) instead of char(80). That breaks databases that already have users with names longer than 16 characters.

      In the attachment is a patch that fixes the problem (with a test).

      Attachments

        Issue Links

          Activity

            People

              elenst Elena Stepanova
              pivanof Pavel Ivanov
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.