Function Differences Between MariaDB 10.3 and MySQL 8.0

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

Present in MariaDB Only

Dynamic Columns

General

Geographical

MySQL has removed the following functions in MySQL 8.0.

JSON

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

• MBRCOVEREDBY

• MBRCovers

• ST_BUFFER_STRATEGY

• ST_GeoHash

JSON

• JSON_ARRAYAGG

• JSON_OBJECTAGG

• JSON_PRETTY

• JSON_STORAGE_FREE

Regular Expressions

• REGEXP_LIKE ()

UUID

• BIN_TO_UUID

• IS_UUID

• UUID_TO_BIN

Miscellaneous

• ANY_VALUE

• GROUPING

• RANDOM_BYTES

• RELEASE_ALL_LOCKS

See Also