The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Function Differences Between MariaDB 10.5 and MySQL 8.0

Contents

  1. Present in MariaDB Only
    1. Dynamic Columns
    2. Galera
    3. General
    4. Geographical
    5. JSON
    6. Sequences
    7. Window Functions
  2. Present in MySQL Only
    1. GTID
    2. Geographic
    3. JSON
    4. Regular Expressions
    5. UUID
    6. Miscellaneous
  3. See Also

The following is a list of all function differences between MariaDB 10.5 and MySQL 8.0. It is based on functions available in the MySQL 8.0.17 and the MariaDB 10.5.19 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 10.5 and MySQL 8.0

Present in MariaDB Only

Dynamic Columns

Galera

General

Geographical

MySQL has removed the following functions in MySQL 8.0.

JSON

Sequences

Window Functions

Present in MySQL Only

GTID

MariaDB and MySQL have differing GTID implementations.

  • GTID_SUBSET
  • GTID_SUBTRACT
  • WAIT_FOR_EXECUTED_GTID_SET
  • WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()

Geographic

  • MBRCOVEREDBY
  • MBRCovers
  • ST_BUFFER_STRATEGY
  • ST_GeoHash
  • ST_IsValid
  • ST_LatFromGeoHash
  • ST_Latitude
  • ST_LongFromGeoHash
  • ST_Longitude
  • ST_PointFromGeoHash
  • ST_SIMPLIFY
  • ST_TRANSFORM
  • ST_VALIDATE

JSON

  • JSON_OVERLAPS
  • JSON_SCHEMA_VALID (MDEV-27128)
  • JSON_SCHEMA_VALIDATION_REPORT
  • JSON_STORAGE_FREE
  • JSON_STORAGE_SIZE (MDEV-17397)
  • JSON_TABLE
  • MEMBER_OF operator

Regular Expressions

UUID

  • BIN_TO_UUID
  • IS_UUID
  • UUID_TO_BIN

Miscellaneous

See Also

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.