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

MySQL 8.0 desired compatibility

    XMLWordPrintable

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

          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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-5561 Query Rewrite Plugin API

          • 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

          New Feature - A new feature of the product, which has yet to be developed. 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_sha2_password plugin

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-10267 Add "ngram" support to MariaDB

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-10426 ANY_VALUE function

          • Major - Major loss of function.
          • In Testing

          New Feature - A new feature of the product, which has yet to be developed. MDEV-10526 Support bitwise operators for binary and bit types

          • Major - Major loss of function.
          • In Review

          New Feature - A new feature of the product, which has yet to be developed. MDEV-10964 Support for NULL/NOT NULL syntax for virtual columns

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-11588 Support for ONLY_FULL_GROUP_BY functional dependency

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-12981 lead and lag don't support defaults

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-12984 support IGNORE/RESPECT NULLS for window functions

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-13594 Support for JSON operators column->path and column->>path

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

          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.
          • Confirmed

          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)

          • Major - Major loss of function.
          • Open

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

          • 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-17397 Implement JSON functions available in MySQL 8.0 but not 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-17398 Implement Geographic functions available in MySQL 8.0

          • Major - Major loss of function.
          • Closed

          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-19077 Support derived tables / CTE with external references

          • 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-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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19502 TIME_ROUND_FRACTIONAL is not respected on TIME->BIGINT conversion

          • Major - Major loss of function.
          • Open

          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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-21753 convert the upstream"s "*-info-repository=TABLE" tables into info files

          • Major - Major loss of function.
          • Stalled

          New Feature - A new feature of the product, which has yet to be developed. MDEV-21921 Make transaction_isolation into a system variable

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-22269 GROUPING() function

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-22310 Support zstd Compression algorithm in the client-server protocol

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-23168 Implement SESSION_TRACK_GTIDS exactly

          • Major - Major loss of function.
          • Stalled

          New Feature - A new feature of the product, which has yet to be developed. MDEV-23501 support NULL for secure_file_priv parameter

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-25150 JSON_TABLE: support all data types (ENUM, SET, geometry, INET6, etc)

          • Major - Major loss of function.
          • Confirmed

          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

          • Major - Major loss of function.
          • 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.
          • Open

          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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-28876 Change innodb_open_files to dynamic

          • 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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-29919 Support MYSQL Syntax for INSERT ON DUPLICATE KEY UPDATE

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

          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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-30543 Request new status variable: Max_used_connections_time

          • 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-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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-31669 performance_schema not to use md5 for digest

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-32222 different behaviour with "INTO @var1" for MySQL and MariaDB

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-32362 Handle generated columns in mariadb-dump INSERT statements

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

          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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-33241 support explict ROW syntax in select * from (values row(2)) t;

          • 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.
          • Closed

          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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34916 Implement Remaining GIS Functions

          • Major - Major loss of function.
          • Open

          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-35744 Add new option for mariadb-dump to ignore all views

          • 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-35831 MYSQL_TYPE_VECTOR

          • 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-35841 replicate MySQL 9.0 Vector to MariaDB

          • 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-35856 MySQL 8-style optimizer hints: milestone 2: index hints

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36166 support for notation with brackets inside MULTIPOINT

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37396 Failed restore MySQL 8.0 users from mariadb-dump file

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37403 MariaDB does not support regexp_time_limit parameter

          • 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-37421 Allow for uses of $1, $2 within REGEXP_REPLACE

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38417 Update Incompatibilities and Feature Differences Between MariaDB Rolling and MySQL 8.0 page

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-38524 Extend CREATE USER statement to allow HEX strings

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-38591 MEMBER OF json operator

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-39273 Add support for dual passwords

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

          Task - A task that needs to be done. MDEV-40580 make secure-file-priv=/tmp by default

          • Major - Major loss of function.
          • Open
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-10658 Support TLS SNI in MariaDB

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-10066 Implement a parallel replication mode that works with a MySQL master

          • 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-12983 support from last / first first with nth_value window function

          • Major - Major loss of function.
          • Open

          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.
          • 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-38857 MySQL to MariaDB automation

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

          Activity

            People

              monty Michael Widenius
              monty Michael Widenius
              Votes:
              7 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 50d
                  50d
                  Remaining:
                  Remaining Estimate - 50d
                  50d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                  Git Integration

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