Function Differences Between MariaDB 10.3 and MySQL 8.0
Contents
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
Sequences
Window Functions
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_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
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
