Function Differences Between MariaDB Rolling and MySQL 8.0

You are viewing an old version of this article. View the current version here.

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

Present in MariaDB Only

Dynamic Columns

Galera

General

Geographic

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
  • ST_BUFFER_STRATEGY
  • ST_Collect
  • ST_FrechetDistance
  • ST_GeoHash
  • ST_HausdorffDistance
  • ST_LatFromGeoHash
  • ST_LATITUDE
  • ST_LineInterpolatePoint
  • ST_LineInterpolatePoints
  • ST_LongFromGeoHash
  • ST_LONGITUDE
  • ST_PointAtDistance
  • ST_PointFromGeoHash (MDEV-17398)

JSON

  • JSON_SCHEMA_VALIDATION_REPORT
  • JSON_STORAGE_FREE
  • JSON_STORAGE_SIZE (MDEV-17397)
  • MEMBER_OF operator

Regular Expressions

UUID

Miscellaneous

  • ANY_VALUE (MDEV-10426)
  • ASYNCHRONOUS_CONNECTION_FAILOVER_ADD_SOURCE
  • ASYNCHRONOUS_CONNECTION_FAILOVER_DELETE_SOURCE
  • FORMAT_BYTES (MDEV-19629)
  • GROUPING (MDEV-32789)
  • PS_THREAD_ID (MDEV-19629)
  • PS_CURRENT_THREAD_ID
  • SOURCE_POS_WAIT
  • VALIDATE_PASSWORD_STRENGTH (MDEV-25703)

See Also

Comments

Comments loading...
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.