[MDEV-28906] MySQL 8.0 desired compatibility Created: 2022-06-20  Updated: 2024-01-20

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Michael Widenius Assignee: Michael Widenius
Resolution: Unresolved Votes: 3
Labels: None

Issue Links:
PartOf
includes MDEV-7495 GB18030 Open
includes MDEV-7850 Extend GTID Binlog Events with Thread Id In Progress
includes MDEV-9069 extend AES_ENCRYPT() and AES_DECRYPT(... Closed
includes MDEV-9804 Implement a sha256_password / caching... Open
includes MDEV-10426 ANY_VALUE function as a workaround fo... Open
includes MDEV-10526 Support bitwise operators for binary ... Open
includes MDEV-13594 Support for JSON operators column->pa... Open
includes MDEV-15854 Implement uuid_to_bin, bin_to_uuid an... Open
includes MDEV-16228 System variables retentive setting (a... Open
includes MDEV-16599 Add REGEXP_LIKE function Open
includes MDEV-17398 Implement Geographic functions availa... Open
includes MDEV-17514 Please implement FOR UPDATE OF tablen... Open
includes MDEV-18394 DELIMITER not working in mysqld init-... Open
includes MDEV-19077 Support derived tables / CTE with ext... Open
includes MDEV-19078 Support lateral derived tables Open
includes MDEV-19095 [feature] Issue: #45 Support for INVI... Open
includes MDEV-19160 JSON_DETAILED output unnecessarily ve... Closed
includes MDEV-19248 Implement MASTER_BIND for CHANGE MASTER Open
includes MDEV-19629 Implement MySQL 8.0 native functions:... Open
includes MDEV-20912 Add support for utf8mb4_0900_* collat... Closed
includes MDEV-21113 CREATE USER IDENTIFIED BY RANDOM PASS... Open
includes MDEV-21921 Make transaction_isolation into a sys... Closed
includes MDEV-22269 Mariadb lacks GROUPING() function Open
includes MDEV-25247 CREATE VIEW SELECT ... [NOWAIT|WAIT] Open
includes MDEV-25515 Request: User Account Host Names usin... Open
includes MDEV-25703 Add VALIDATE_PASSWORD_STRENGTH function Closed
includes MDEV-25704 Add RANDOM_BYTES function Closed
includes MDEV-26259 P_S functions STATEMENT_DIGEST_TEXT a... Stalled
includes MDEV-26318 update P_S to 8.0.x Open
includes MDEV-26591 Is MariaDB really caching or reusing ... Open
includes MDEV-27677 Implement JSON_OVERLAPS() Closed
includes MDEV-28876 add "SELECT innodb_set_open_files_li... Open
includes MDEV-29209 Implement connection response delay a... Stalled
includes MDEV-29253 Detect incompatible MySQL partition s... Closed
includes MDEV-29254 Easy upgrade from MySQL 8.0 to MariaDB Open
includes MDEV-29448 mysqldump missing option to match MyS... Open
includes MDEV-29953 Support CREATE SPATIAL REFERENCE SYSTEM Open
includes MDEV-30017 MariaDB optimizer significantly slowe... Open
includes MDEV-30543 Request new status variable: Max_used... Closed
includes MDEV-30813 RESTART statement Open
includes MDEV-30814 RENAME tables locked with a write lock Open
includes MDEV-31669 performance_schema to use sha2-256 as... Open
includes MDEV-32727 No warning and misleading error messa... Open
includes MDEV-32789 Add GROUPING function Closed
includes MDEV-33281 Implement hints like in MySQL 8 ? Open
Relates
relates to MDEV-10658 Support TLS SNI in MariaDB Open
relates to MDEV-10137 Providing compatibility to other data... Open
relates to MDEV-26634 Feature request: add STATEMENT_DIGEST... Closed
relates to MDEV-29533 Crash when MariaDB is replica of MySQ... Confirmed

 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.

 Comments   
Comment by Nuno [ 2022-06-22 ]

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

Generated at Thu Feb 08 10:04:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.