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