Function Differences Between MariaDB 10.2 and MySQL 5.7

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

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

JSON

Regular Expressions

Window Functions

Present in MySQL Only

GTID

MariaDB and MySQL have differing implementations.

• GTID_SUBSET

• GTID_SUBTRACT

• WAIT_FOR_EXECUTED_GTID_SET

• WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()

Geographic

• DISTANCE

• MBRCOVEREDBY

• ST_BUFFER_STRATEGY

• ST_GeoHash

Miscellaneous

• ANY_VALUE

• RANDOM_BYTES

• RELEASE_ALL_LOCKS

• VALIDATE_PASSWORD_STRENGTH

See Also