Function Differences Between MariaDB 11.8 and MySQL 8.0

The following is a list of all function differences between MariaDB 11.8 and MySQL 8.0. It is based on functions available in the MySQL 8.0.43 and the MariaDB 11.8.3 releases.

Present in MariaDB Only

Dynamic Columns

• COLUMN_ADD

• COLUMN_CHECK

• COLUMN_CREATE

• COLUMN_DELETE

• COLUMN_EXISTS

• COLUMN_GET

• COLUMN_JSON

• COLUMN_LIST

Galera

• WSREP_LAST_SEEN_GTID

• WSREP_LAST_WRITTEN_GTID

• WSREP_SYNC_WAIT_UPTO_GTID

General

• ADD_MONTHS

• CHR

• DECODE_ORACLE

• DES_DECRYPT

• DES_ENCRYPT

• KDF

• LENGTHB

• NATURAL_SORT_KEY

• NVL (Synonym for IFNULL)

• NVL2

• SFORMAT

• SYS_GUID

• TO_CHAR

• TRIM_ORACLE

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

Geographic

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_ARRAY_INTERSECT

• JSON_COMPACT

• JSON_DETAILED

• JSON_EQUALS

• JSON_EXISTS

• JSON_KEY_VALUE

• JSON_LOOSE

• JSON_NORMALIZE

• JSON_OBJECT_FILTER_KEYS

• JSON_OBJECT_TO_ARRAY

• JSON_QUERY

Sequences

• LASTVAL

• NEXTVAL

• SETVAL

Vectors

• VEC_DISTANCE

• VEC_DISTANCE_COSINE

• VEC_DISTANCE_EUCLIDEAN

• VEC_FromText

• VEC_ToText

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

• GeomCollection

• MBRCovers

• ST_Buffer_Strategy

• ST_FrechetDistance

• ST_GeomCollFromTxt

• ST_HausdorffDistance

• ST_Latitude

• ST_LineInterpolatePoint

• ST_LineInterpolatePoints

• ST_Longitude

• ST_MakeEnvelope

• ST_NumInteriorRing

• ST_PointAtDistance

• ST_SwapXY

• ST_Transform

JSON

• JSON_SCHEMA_VALIDATION_REPORT

• JSON_STORAGE_FREE

• JSON_STORAGE_SIZE (MDEV-17397)

• MEMBER_OF operator

Regular Expressions

• REGEXP_LIKE (MDEV-16599)

UUID

• BIN_TO_UUID

• IS_UUID

• UUID_TO_BIN (MDEV-15854)

Miscellaneous

• ANY_VALUE (MDEV-10426)

• ASYNCHRONOUS_CONNECTION_FAILOVER_ADD_SOURCE

• ASYNCHRONOUS_CONNECTION_FAILOVER_DELETE_SOURCE

• FORMAT_BYTES (MDEV-19629)

• GROUPING (MDEV-32789)

• PS_THREAD_ID (MDEV-19629)

• PS_CURRENT_THREAD_ID

• SOURCE_POS_WAIT

• VALIDATE_PASSWORD_STRENGTH (MDEV-25703)

See Also

• Function Differences Between MariaDB 11.4 and MySQL 8.0

• System Variable Differences Between MariaDB Rolling and MySQL 8.0

• MariaDB versus MySQL - Compatibility

• MariaDB versus MySQL - Features