Function Differences Between MariaDB Rolling and MySQL 8.0
Contents
The following is a list of all function differences between MariaDB 11.7 Rolling Release, and MySQL 8.0. It is based on functions available in the MySQL 8.0.39 and the MariaDB 11.7.0 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB Rolling 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
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
Vectors
- [[|vec_distance_cosine|VEC_DISTANCE_COSINE]]
- VEC_DISTANCE_EUCLIDEAN
- VEC_FromText
- VEC_ToText
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
- MBRCovers
- ST_Buffer_Strategy
- ST_FrechetDistance
- ST_HausdorffDistance
- ST_Latitude
- ST_LineInterpolatePoint
- ST_LineInterpolatePoints
- ST_Longitude
- ST_PointAtDistance
- ST_PointFromGeoHash (MDEV-17398)
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
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.
