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

• COLUMN_ADD
• COLUMN_CHECK
• COLUMN_CREATE
• COLUMN_DELETE
• COLUMN_EXISTS
• COLUMN_GET
• COLUMN_JSON
• COLUMN_LIST

General

• CHR
• DECODE_ORACLE
• LENGTHB
• NVL (Synonym for IFNULL)
• NVL2
• TRIM_ORACLE
• VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.

JSON

• JSON_COMPACT
• JSON_DETAILED
• JSON_EXISTS
• JSON_LOOSE
• JSON_MERGE_PATCH
• JSON_MERGE_PRESERVE
• JSON_QUERY
• JSON_VALUE

Regular Expressions

• REGEXP_INSTR
• REGEXP_REPLACE
• REGEXP_SUBSTR

Sequences

• LASTVAL
• NEXTVAL
• SETVAL

Window Functions

• CUME_DIST
• DENSE_RANK
• LAG
• LAST_VALUE
• LEAD
• MEDIAN
• NTH_VALUE
• NTILE
• PERCENT_RANK
• PERCENTILE_CONT
• PERCENTILE_DISC
• RANK
• ROW_NUMBER

Present in MySQL Only

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_GeoHash
• ST_IsValid
• ST_LatFromGeoHash
• ST_LongFromGeoHash
• ST_PointFromGeoHash
• ST_SIMPLIFY
• ST_VALIDATE

Miscellaneous

• ANY_VALUE
• RANDOM_BYTES
• RELEASE_ALL_LOCKS
• VALIDATE_PASSWORD_STRENGTH

See Also

• Incompatibilities and Feature Differences Between MariaDB 10.3 and MySQL 5.7
• System Variable Differences Between MariaDB 10.3 and MySQL 5.7
• Function Differences Between MariaDB 10.2 and MySQL 5.7