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

• COLUMN_ADD

• COLUMN_CHECK

• COLUMN_CREATE

• COLUMN_DELETE

• COLUMN_EXISTS

• COLUMN_GET

• COLUMN_JSON

• COLUMN_LIST

General

• CHR

• DECODE_ORACLE

• DES_DECRYPT

• DES_ENCRYPT

• LENGTHB

• NVL (Synonym for IFNULL)

• NVL2

• TRIM_ORACLE

• VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.

Geographical

MySQL has removed the following functions in MySQL 8.0.

• AREA

• AsBinary

• AsText

• AsWKB

• AsWKT

• Buffer

• Centroid

• Contains

• ConvexHull

• Crosses

• Dimension

• Disjoint

• EndPoint

• Envelope

• Equals

• ExteriorRing

• GeomCollFromText

• GeomCollFromWKB

• GeomFromText

• GeomFromWKB

• GeometryCollectionFromText

• GeometryCollectionFromWKB

• GeometryFromText

• GeometryFromWKB

• GeometryN

• GeometryType

• GLENGTH

• InteriorRingN

• Intersects

• IsClosed

• IsEmpty

• IsSimple

• LineFromText

• LineFromWKB

• LineStringFromText

• LineStringFromWKB

• MLineFromText

• MLineFromWKB

• MPointFromText

• MPointFromWKB

• MPolyFromText

• MPolyFromWKB

• MultiLineStringFromText

• MultiLineStringFromWKB

• MultiPointFromText

• MultiPointFromWKB

• MultiPolygonFromText

• MultiPolygonFromWKB

• NumGeometries

• NumInteriorRings

• NumPoints

• Overlaps

• PointFromText

• PointFromWKB

• PointN

• PolyFromText

• PolyFromWKB

• PolygonFromText

• PolygonFromWKB

• SRID

• StartPoint

• Touches

• Within

• X

• Y

JSON

• JSON_COMPACT

• JSON_DETAILED

• JSON_EXISTS

• JSON_LOOSE

• JSON_QUERY

• JSON_VALUE

Sequences

• LASTVAL

• NEXTVAL

• SETVAL

Window Functions

• MEDIAN

• PERCENTILE_CONT

• PERCENTILE_DISC

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

• MBRCOVEREDBY

• MBRCovers

• ST_BUFFER_STRATEGY

• ST_GeoHash

• ST_IsValid

• ST_LatFromGeoHash

• ST_LongFromGeoHash

• ST_MakeEnvelope

• ST_PointFromGeoHash

• ST_SIMPLIFY

• ST_VALIDATE

JSON

• JSON_ARRAYAGG

• JSON_OBJECTAGG

• JSON_PRETTY

• JSON_STORAGE_FREE

• JSON_STORAGE_SIZE

• JSON_TABLE

Regular Expressions

• REGEXP_LIKE (MDEV-16599)

UUID

• BIN_TO_UUID

• IS_UUID

• UUID_TO_BIN

Miscellaneous

• ANY_VALUE

• GROUPING

• RANDOM_BYTES

• RELEASE_ALL_LOCKS

• VALIDATE_PASSWORD_STRENGTH

See Also

• Function Differences Between MariaDB 10.3 and MySQL 5.7

• System Variable Differences Between MariaDB 10.3 and MySQL 8.0

• MariaDB versus MySQL - Compatibility

• MariaDB versus MySQL - Features