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

MySQL 8.0 desired compatibility

Details

    Description

      Collection of all tasks related to making MariaDB compatible with MySQL 8.0

      Some minor MySQL 8.0 compatibility issues are left out as they don't work well with MariaDB internals and are likely to never be implemented.

      Attachments

        Issue Links

          includes

          Bug - A problem which impairs or prevents the functions of the product. CONC-727 LIBMYSQL_VERSION_ID (and MYSQL_VERSION_ID)

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. CONC-728 mysql_real_connect_dns_srv()

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. CONC-729 MYSQL_OPT_SSL_MODE

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-7495 Support GB18030 character set

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-7850 Extend GTID Binlog Events with Thread Id

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

          Task - A task that needs to be done. MDEV-9069 extend AES_ENCRYPT() and AES_DECRYPT() to support IV and the algorithm

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-9804 Implement a caching_sha256_password plugin

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

          Task - A task that needs to be done. MDEV-10426 ANY_VALUE function as a workaround for ONLY_FULL_GROUP_BY mode, SQL-2023-T626, and compatibility with MySQL 5.7

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-10526 Support bitwise operators for binary and bit types

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-13594 Support for JSON operators column->path and column->>path

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-15854 Implement uuid_to_bin, bin_to_uuid and is_uuid functions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-16228 System variables retentive setting (a.k.a. SET PERSIST)

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

          Task - A task that needs to be done. MDEV-16599 Add REGEXP_LIKE function

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-17398 Implement Geographic functions available in MySQL 8.0

          • Major - Major loss of function.
          • Stalled

          Task - A task that needs to be done. MDEV-17514 Please implement FOR UPDATE OF tablename,... and FOR SHARE OF tablename,...

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-17856 Port binlog_error_action from MySQL

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-17994 Add "Resource Group" feature in MariaDB

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-18394 DELIMITER not working in mysqld init-file

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-19077 Support derived tables / CTE with external references

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-19078 Support lateral derived tables

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-19095 [feature] Issue: #45 Support for INVISIBLE indexes

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19160 JSON_DETAILED output unnecessarily verbose (Part Time project)

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-19248 Implement MASTER_BIND for CHANGE MASTER

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

          Task - A task that needs to be done. MDEV-19629 Implement MySQL 8.0 native functions: format_bytes(), format_pico_time() and ps_thread_id()

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-20912 Add support for utf8mb4_0900_* collations in MariaDB Server

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-21113 CREATE USER IDENTIFIED BY RANDOM PASSWORD

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-21921 Make transaction_isolation into a system variable

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-22269 Mariadb lacks GROUPING() function

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-25247 CREATE VIEW SELECT ... [NOWAIT|WAIT]

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-25291 Add support for missing MySQL collations

          • Major - Major loss of function.
          • Needs Feedback

          New Feature - A new feature of the product, which has yet to be developed. MDEV-25515 Request: User Account Host Names using CIDR notation

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-25703 Add VALIDATE_PASSWORD_STRENGTH function

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Task - A task that needs to be done. MDEV-25704 Add RANDOM_BYTES function

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-26259 P_S functions STATEMENT_DIGEST_TEXT and STATEMENT_DIGEST are missing

          • Major - Major loss of function.
          • Stalled

          Task - A task that needs to be done. MDEV-26318 update P_S to 8.0.x

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26591 Is MariaDB really caching or reusing “WITH” intermediary results?

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-27677 Implement JSON_OVERLAPS()

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-28876 add "SELECT innodb_set_open_files_limit(N)" for dynamic innodb_open_files

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-29209 Implement connection response delay after a number of failed login attempts

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Stalled

          Task - A task that needs to be done. MDEV-29253 Detect incompatible MySQL partition scheme and either convert them or report to user and in error log.

          • Major - Major loss of function.
          • Closed

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-29254 Easy upgrade from MySQL 8.0 to MariaDB

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-29448 mysqldump missing option to match MySQL existing options

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-29953 Support CREATE SPATIAL REFERENCE SYSTEM

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30017 MariaDB optimizer significantly slower with CTE than competitive product

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-30543 Request new status variable: Max_used_connections_time

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Task - A task that needs to be done. MDEV-30813 RESTART statement

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-30814 RENAME tables locked with a write lock

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-31669 performance_schema to use sha2-256 as a digest instead of md5

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32362 Backup of VIRTUALS colums is represented in restore

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32727 No warning and misleading error message for PARTITION BY KEY with index prefixes

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-32789 Add GROUPING function

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-33018 Support LEFT JOIN LATERAL

          • Major - Major loss of function.
          • Open

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-33281 Implement optimizer hints like in MySQL 8

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-33988 DELETE (single table) to support table aliases

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34192 Support GTID_Anonymous to replicate MariaDB ⮕ MySQL with GTID_MODE = ON

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34864 SHOW INDEX FROM - SEQ_IN_INDEX - mysql-connector-net incompatiblity

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35642 Support replication from MySQL 8.0 to MariaDB

          • Major - Major loss of function.
          • Stalled

          New Feature - A new feature of the product, which has yet to be developed. MDEV-35856 MySQL 8-style optimizer hints: milestone 2: index hints

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          relates to

          Task - A task that needs to be done. MDEV-10658 Support TLS SNI in MariaDB

          • Major - Major loss of function.
          • Open

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-35388 Postgres compatible syntax

          • Major - Major loss of function.
          • Open

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-10137 Providing compatibility to other databases

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-26634 Feature request: add STATEMENT_DIGEST_TEXT

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29533 Crash when MariaDB is replica of MySQL 8.0

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35519 Populate thread_id of Backward Compatibility Query event

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • In Review

          Activity

            Ascending order - Click to sort in descending order
            monty Michael Widenius created issue -
            monty Michael Widenius made changes -
            Field Original Value New Value
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            greenman Ian Gilfillan made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            Summary MySQL 8.0 compatibility MySQL 8.0 desired compatibility
            monty Michael Widenius made changes -
            Description Collection of all tasks related to making MariaDB compatible with MySQL 8.0 Collection of all tasks related to making MariaDB compatible with MySQL 8.0

            Some minor MySQL 8.0 compatibility issues are left out as they don't work well with MariaDB internals and are likely to never be implemented.
            monty Michael Widenius made changes -
            nunop Nuno added a comment -

            Looking forward for [ MDEV-19078 Support lateral derived tables ]
            Keep finding scenarios where I wish LATERAL existed, and have to find workarounds or use less-efficient ways to get a similar result.

            Thank you very much

            nunop Nuno added a comment - Looking forward for [ MDEV-19078 Support lateral derived tables ] Keep finding scenarios where I wish LATERAL existed, and have to find workarounds or use less-efficient ways to get a similar result. Thank you very much
            elenst Elena Stepanova made changes -
            Issue Type Bug [ 1 ] Task [ 3 ]
            greenman Ian Gilfillan made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            marko Marko Mäkelä made changes -
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            mg MG made changes -
            greenman Ian Gilfillan made changes -
            greenman Ian Gilfillan made changes -
            greenman Ian Gilfillan made changes -
            greenman Ian Gilfillan made changes -
            danblack Daniel Black made changes -
            greenman Ian Gilfillan made changes -
            greenman Ian Gilfillan made changes -
            greenman Ian Gilfillan made changes -
            greenman Ian Gilfillan made changes -
            greenman Ian Gilfillan made changes -
            greenman Ian Gilfillan made changes -
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            greenman Ian Gilfillan made changes -
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            greenman Ian Gilfillan made changes -
            greenman Ian Gilfillan made changes -
            serg Sergei Golubchik made changes -
            danblack Daniel Black made changes -
            greenman Ian Gilfillan made changes -
            danblack Daniel Black made changes -
            GreenReaper Laurence Parry made changes -
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            rsilen Robert Silén made changes -
            rsilen Robert Silén made changes -
            rsilen Robert Silén made changes -
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            bnestere Brandon Nesterenko made changes -
            ParadoxV5 Jimmy HĂş made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Compatibility
            danblack Daniel Black made changes -
            greenman Ian Gilfillan made changes -
            Labels Compatibility Compatibility compat80
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -

            People

              monty Michael Widenius
              monty Michael Widenius
              Votes:
              5 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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