The Ultimate Guide to High Availability with MariaDB

Function Differences Between MariaDB 10.3 and MySQL 5.7

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

MariaDB 10.3 is currently in alpha, so the information on this page may change frequently.

Contents

  1. Present in MariaDB only
    1. Dynamic columns
    2. JSON
    3. Regular expressions
    4. Sequences
    5. Window functions
  2. Present in MySQL only
    1. JSON
    2. GTID
    3. Geographic
    4. Miscellaneous
  3. See also

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 alpha version MariaDB 10.3.1.

Present in MariaDB only

Dynamic columns

JSON

Regular expressions

Sequences

Window functions

Present in MySQL only

JSON

  • JSON_APPEND

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