Function Differences Between MariaDB 10.2 and MySQL 5.6

The following is a list of all function differences between MariaDB 10.2 and MySQL 5.6. It is based on functions available in the stable version MariaDB 10.2.25.

Present in MariaDB Only

Dynamic Columns

• COLUMN_ADD

• COLUMN_CHECK

• COLUMN_CREATE

• COLUMN_DELETE

• COLUMN_EXISTS

• COLUMN_GET

• COLUMN_JSON

• COLUMN_LIST

JSON

• JSON_ARRAY

• JSON_ARRAY_APPEND

• JSON_ARRAY_INSERT

• JSON_COMPACT

• JSON_CONTAINS

• JSON_CONTAINS_PATH

• JSON_DEPTH

• JSON_DETAILED

• JSON_EXISTS

• JSON_EXTRACT

• JSON_INSERT

• JSON_KEYS

• JSON_LENGTH

• JSON_LOOSE

• JSON_MERGE

• JSON_MERGE_PATCH

• JSON_MERGE_PRESERVE

• JSON_OBJECT

• JSON_QUERY

• JSON_QUOTE

• JSON_REMOVE

• JSON_REPLACE

• JSON_SEARCH

• JSON_SET

• JSON_TYPE

• JSON_UNQUOTE

• JSON_VALID

• JSON_VALUE

Regular Expressions

• REGEXP_INSTR

• REGEXP_REPLACE

• REGEXP_SUBSTR

Window Functions

• CUME_DIST

• DENSE_RANK

• LAG

• LAST_VALUE

• LEAD

• NTH_VALUE

• NTILE

• PERCENT_RANK

• RANK

• ROW_NUMBER

Present in MySQL Only

GTID

MariaDB and MySQL have differing GTID implementations.

• GTID_SUBSET

• GTID_SUBTRACT

• SQL_THREAD_WAIT_AFTER_GTIDS()

• WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()

Miscellaneous

• RANDOM_BYTES

• VALIDATE_PASSWORD_STRENGTH

See Also

• Function Differences Between MariaDB 10.2 and MySQL 5.7

• System Variable Differences Between MariaDB 10.2 and MySQL 5.6

• MariaDB versus MySQL - Compatibility

• MariaDB versus MySQL - Features