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

Compatibility issues between 10.2 and MySQL 5.7

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

            Ascending order - Click to sort in descending order
            otto Otto Kekäläinen added a comment -

            ratzpo What is the plan here? In buildbot we test 5.7 -> 10.2 upgrades, and so far they always fail. Does the test mirror the target state or should the test step be removed or changed to a 5.6 -> 10.2 test?

            otto Otto Kekäläinen added a comment - ratzpo What is the plan here? In buildbot we test 5.7 -> 10.2 upgrades, and so far they always fail. Does the test mirror the target state or should the test step be removed or changed to a 5.6 -> 10.2 test?
            greenman Ian Gilfillan added a comment -

            Should this task be re-aimed at 10.3 now? There are quite a few variables in MySQL 5.7 not present in MariaDB. They're listed at https://mariadb.com/kb/en/the-mariadb-library/system-variable-differences-between-mariadb-103-and-mysql-57/

            greenman Ian Gilfillan added a comment - Should this task be re-aimed at 10.3 now? There are quite a few variables in MySQL 5.7 not present in MariaDB. They're listed at https://mariadb.com/kb/en/the-mariadb-library/system-variable-differences-between-mariadb-103-and-mysql-57/
            elenst Elena Stepanova added a comment -

            I'm not aware of any planned effort for 10.3 to be "more compatible" with MySQL 5.7 than 10.2. I'll leave it to ratzpo and serg to decide whether we need a task for it in 10.3.

            elenst Elena Stepanova added a comment - I'm not aware of any planned effort for 10.3 to be "more compatible" with MySQL 5.7 than 10.2. I'll leave it to ratzpo and serg to decide whether we need a task for it in 10.3.
            serg Sergei Golubchik added a comment -

            Having some of that in 10.3 is still possible, but not very likely.

            serg Sergei Golubchik added a comment - Having some of that in 10.3 is still possible, but not very likely.
            danblack Daniel Black added a comment -

            Account locking implemented in MDEV-13095 (10.4).

            updated:
            https://mariadb.com/kb/en/incompatibilities-and-feature-differences-between-mariadb-102-and-mysql-57/ and 10.3 version too.

            Given the age of this bug now, I suspect the the satisfaction with level of compatibility has been reached.

            danblack Daniel Black added a comment - Account locking implemented in MDEV-13095 (10.4). updated: https://mariadb.com/kb/en/incompatibilities-and-feature-differences-between-mariadb-102-and-mysql-57/ and 10.3 version too. Given the age of this bug now, I suspect the the satisfaction with level of compatibility has been reached.

            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.