Function Differences Between MariaDB 10.3 and MySQL 5.7

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

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

Present in MariaDB Only

Dynamic Columns

General

• (Synonym for IFNULL)

JSON

Regular Expressions

Sequences

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