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 version MySQL 5.7.18 and the beta version MariaDB 10.3.3.

Present in MariaDB only

Dynamic Columns

General

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

JSON

Regular Expressions

Sequences

Window Functions

Present in MySQL Only

JSON

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