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

Compatibility issues between 10.2 and MySQL 5.7

    XMLWordPrintable

Details

    Description

      We need to define to which extent MariaDB 10.2 should be compatible with MySQL 5.7.

      For MariaDB 10.0/10.1 the major obstacle is MDEV-9904 (closed as "Won't fix").
      For MariaDB 10.2, it is not a problem after InnoDB 5.7 has been merged; but it still can't start on MySQL 5.7 datadir due to MDEV-11170.
      I expect there will be other issues, so this entry will be an umbrella bug until we are satisfied with the level of compatibility we provide.

      Not supported in 10.2

      This section will contain random features, syntax and options that I encounter during testing as not supported in 10.2, while supported in MySQL 5.7.
      It is not intended to be a full list!

      CREATE USER ... PASSWORD EXPIRE ... (see MDEV-7597)
      CREATE USER ... ACCOUNT [UN]LOCK
      CREATE USER ... IDENTIFIED WITH ... BY ... (see MDEV-11180)

      Attachments

        Issue Links

          includes

          Task - A task that needs to be done. MDEV-10346 Create bind-address as a system variable

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-13117 mysqldump to support --skip-definer

          • Major - Major loss of function.
          • Open
          is blocked by

          Task - A task that needs to be done. MDEV-6113 merge 5.7 innodb

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11170 MariaDB 10.2 cannot start on MySQL 5.7 datadir: Fatal error: mysql.user table is damaged or in unsupported 3.20 format

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.