Function Differences Between MariaDB 10.5 and MySQL 8.0

The following is a list of all function differences between MariaDB 10.5 and MySQL 8.0. It is based on functions available in the MySQL 8.0.17 and the MariaDB 10.5.19 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 10.5 and MySQL 8.0

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

• 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

• GeomCollection

• MBRCoveredBy

• MBRCovers

• ST_Buffer_Strategy

• ST_GeoHash

• ST_GeomCollFromTxt

• ST_IsValid

• ST_LatFromGeoHash

• ST_Latitude

• ST_LongFromGeoHash

• ST_Longitude

• ST_MakeEnvelope

• ST_NumInteriorRing

• ST_PointFromGeoHash

• ST_Simplify

• ST_SwapXY

• ST_Transform

• ST_Validate

JSON

• JSON_OVERLAPS

• JSON_SCHEMA_VALID (MDEV-27128)

• JSON_SCHEMA_VALIDATION_REPORT

• JSON_STORAGE_FREE

• JSON_STORAGE_SIZE (MDEV-17397)

• JSON_TABLE

• MEMBER_OF operator

Regular Expressions

• REGEXP_LIKE (MDEV-16599)

UUID

• BIN_TO_UUID

• IS_UUID

• UUID_TO_BIN

Miscellaneous

• ANY_VALUE

• FORMAT_BYTES (MDEV-19629)

• FORMAT_PICO_TIME (MDEV-19629)

• GROUPING (MDEV-32789)

• PS_THREAD_ID (MDEV-19629)

• PS_CURRENT_THREAD_ID

• RANDOM_BYTES

• VALIDATE_PASSWORD_STRENGTH

See Also

• Incompatibilities and Feature Differences Between MariaDB 10.5 and MySQL 8.0

• Function Differences Between MariaDB 10.4 and MySQL 8.0

• Function Differences Between MariaDB 10.3 and MySQL 8.0

• System Variable Differences Between MariaDB 10.5 and MySQL 8.0

• MariaDB versus MySQL - Compatibility

• MariaDB versus MySQL - Features