The following is a list of all function differences between MariaDB 10.3 and MySQL 5.7. It is based on functions available in the stable versions MySQL 5.7.18 and MariaDB 10.3.7.

For a description of all differences, see Incompatibilities and Feature Differences Between MariaDB 10.2 and MySQL 5.7.

Present in MariaDB Only

Dynamic Columns

General

  • CHR
  • LENGTHB
  • VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.

JSON

Regular Expressions

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

  • DISTANCE
  • MBRCOVEREDBY
  • ST_BUFFER_STRATEGY
  • ST_DISTANCE_SPHERE
  • ST_GeoHash
  • ST_IsValid
  • ST_LatFromGeoHash
  • ST_LongFromGeoHash
  • ST_PointFromGeoHash
  • ST_SIMPLIFY
  • ST_VALIDATE

Miscellaneous

  • RANDOM_BYTES
  • RELEASE_ALL_LOCKS
  • VALIDATE_PASSWORD_STRENGTH

See Also

Comments

Comments loading...