> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/editions-and-compatibility/comparisons-with-other-databases/function-differences-between-mariadb-and-mysql/function-differences-between-mariadb-and-mysql-unmaintained-series/function-differences-between-mariadb-11-2-and-mysql-8-0.md).

# Function Differences Between MariaDB 11.2 and MySQL 8.0

The following is a list of all function differences between [MariaDB 11.2](https://mariadb.com/docs/release-notes/community-server/old-releases/11.2/what-is-mariadb-112.md) and MySQL 8.0. It is based on functions available in the MySQL 8.0.34 and the [MariaDB 11.2.1](https://mariadb.com/docs/release-notes/community-server/old-releases/11.2/11.2.1.md) releases. For a more complete list of differences, see [Incompatibilities and Feature Differences Between MariaDB 11.2 and MySQL 8.0](https://mariadb.com/docs/server/editions-and-compatibility/comparisons-with-other-databases/incompatibilities-and-feature-differences-between-mariadb-and-mysql-unmaint/incompatibilities-and-feature-differences-between-mariadb-11-2-and-mysql-8.md)

## Present in MariaDB Only

### Dynamic Columns

* [COLUMN\_ADD](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_add.md)
* [COLUMN\_CHECK](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_check.md)
* [COLUMN\_CREATE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_create.md)
* [COLUMN\_DELETE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_delete.md)
* [COLUMN\_EXISTS](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_exists.md)
* [COLUMN\_GET](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_get.md)
* [COLUMN\_JSON](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_json.md)
* [COLUMN\_LIST](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_list.md)

### Galera

* [WSREP\_LAST\_SEEN\_GTID](https://mariadb.com/docs/server/reference/sql-functions/special-functions/galera-functions/wsrep_last_seen_gtid.md)
* [WSREP\_LAST\_WRITTEN\_GTID](https://mariadb.com/docs/server/reference/sql-functions/special-functions/galera-functions/wsrep_last_written_gtid.md)
* [WSREP\_SYNC\_WAIT\_UPTO\_GTID](https://mariadb.com/docs/server/reference/sql-functions/special-functions/galera-functions/wsrep_sync_wait_upto_gtid.md)

### General

* [ADD\_MONTHS](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/add_months.md)
* [CHR](https://mariadb.com/docs/server/reference/sql-functions/string-functions/chr.md)
* [DECODE\_ORACLE](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/decode.md)
* [DES\_DECRYPT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/des_decrypt.md)
* [DES\_ENCRYPT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/des_encrypt.md)
* [LENGTHB](https://mariadb.com/docs/server/reference/sql-functions/string-functions/lengthb.md)
* [NATURAL\_SORT\_KEY](https://mariadb.com/docs/server/reference/sql-functions/string-functions/natural_sort_key.md)
* [NVL](https://mariadb.com/docs/server/reference/sql-functions/control-flow-functions/ifnull.md) (Synonym for IFNULL)
* [NVL2](https://mariadb.com/docs/server/reference/sql-functions/control-flow-functions/nvl2.md)
* [SFORMAT](https://mariadb.com/docs/server/reference/sql-functions/string-functions/sformat.md)
* [SYS\_GUID](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/sys_guid.md)
* [TO\_CHAR](https://mariadb.com/docs/server/reference/sql-functions/string-functions/to_char.md)
* [TRIM\_ORACLE](https://mariadb.com/docs/server/reference/sql-functions/string-functions/trim.md)
* [VALUE](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/values-value.md) - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.

### Geographic

MySQL has removed the following functions in MySQL 8.0.

* [AREA](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/st_area.md)
* [AsBinary](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_asbinary.md)
* [AsText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_astext.md)
* [AsWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/aswkb.md)
* [AsWKT](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_aswkt.md)
* [Buffer](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/buffer.md)
* [Centroid](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/centroid.md)
* [Contains](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/contains.md)
* [ConvexHull](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/convexhull.md)
* [Crosses](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/crosses.md)
* [Dimension](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/dimension.md)
* [Disjoint](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/disjoint.md)
* [EndPoint](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_endpoint.md)
* [Envelope](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_envelope.md)
* [Equals](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/equals.md)
* [ExteriorRing](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/st_exteriorring.md)
* [GeomCollFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_geomcollfromtext.md)
* [GeomCollFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_geomcollfromwkb.md)
* [GeomFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_geomfromtext.md)
* [GeomFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_geomfromwkb.md)
* [GeometryCollectionFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/geometrycollectionfromtext.md)
* [GeometryCollectionFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/geometrycollectionfromwkb.md)
* [GeometryFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/geometryfromtext.md)
* [GeometryFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/geometryfromwkb.md)
* [GeometryN](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_geometryn.md)
* [GeometryType](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_geometrytype.md)
* [GLENGTH](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/glength.md)
* [InteriorRingN](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/st_interiorringn.md)
* [Intersects](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/intersects.md)
* [IsClosed](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/isclosed.md)
* [IsEmpty](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_isempty.md)
* [IsSimple](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_issimple.md)
* [LineFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_linefromtext.md)
* [LineFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_linefromwkb.md)
* [LineStringFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/linestringfromtext.md)
* [LineStringFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/linestringfromwkb.md)
* [MLineFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/mlinefromtext.md)
* [MLineFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/mlinefromwkb.md)
* [MPointFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/mpointfromtext.md)
* [MPointFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/mpointfromwkb.md)
* [MPolyFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/mpolyfromtext.md)
* [MPolyFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/mpolyfromwkb.md)
* [MultiLineStringFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/multilinestringfromtext.md)
* [MultiLineStringFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/multilinestringfromwkb.md)
* [MultiPointFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/multipointfromtext.md)
* [MultiPointFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/multipointfromwkb.md)
* [MultiPolygonFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/multipolygonfromtext.md)
* [MultiPolygonFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/multipolygonfromwkb.md)
* [NumGeometries](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_numgeometries.md)
* [NumInteriorRings](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/st_numinteriorrings.md)
* [NumPoints](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_numpoints.md)
* [Overlaps](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/overlaps.md)
* [PointFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_pointfromtext.md)
* [PointFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_pointfromwkb.md)
* [PointN](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_pointn.md)
* [PolyFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_polyfromtext.md)
* [PolyFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_polyfromwkb.md)
* [PolygonFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/polygonfromtext.md)
* [PolygonFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/polygonfromwkb.md)
* [SRID](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_srid.md)
* [StartPoint](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_startpoint.md)
* [Touches](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/touches.md)
* [Within](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/within.md)
* [X](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/point-properties/st_x.md)
* [Y](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/point-properties/st_y.md)

### JSON

* [JSON\_ARRAY\_INTERSECT](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_array_intersect.md)
* [JSON\_COMPACT](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_compact.md)
* [JSON\_DETAILED](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_detailed.md)
* [JSON\_EQUALS](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_equals.md)
* [JSON\_EXISTS](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_exists.md)
* [JSON\_KEY\_VALUE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_key_value.md)
* [JSON\_LOOSE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_loose.md)
* [JSON\_NORMALIZE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_normalize.md)
* [JSON\_OBJECT\_FILTER\_KEYS](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_object_filter_keys.md)
* [JSON\_OBJECT\_TO\_ARRAY](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_object_to_array.md)
* [JSON\_QUERY](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_query.md)

### Sequences

* [LASTVAL](https://mariadb.com/docs/server/reference/sql-structure/sequences/sequence-functions/previous-value-for-sequence_name.md)
* [NEXTVAL](https://mariadb.com/docs/server/reference/sql-structure/sequences/sequence-functions/next-value-for-sequence_name.md)
* [SETVAL](https://mariadb.com/docs/server/reference/sql-structure/sequences/sequence-functions/setval.md)

### Window Functions

* [MEDIAN](https://mariadb.com/docs/server/reference/sql-functions/special-functions/window-functions/median.md)
* [PERCENTILE\_CONT](https://mariadb.com/docs/server/reference/sql-functions/special-functions/window-functions/percentile_cont.md)
* [PERCENTILE\_DISC](https://mariadb.com/docs/server/reference/sql-functions/special-functions/window-functions/percentile_disc.md)

## Present in MySQL Only

### GTID

MariaDB and MySQL have differing [GTID](https://mariadb.com/docs/server/ha-and-performance/standard-replication/gtid.md) implementations.

* GTID\_SUBSET
* GTID\_SUBTRACT
* WAIT\_FOR\_EXECUTED\_GTID\_SET
* WAIT\_UNTIL\_SQL\_THREAD\_AFTER\_GTIDS

### Geographic

* GeomCollection
* MBRCoveredBy
* MBRCovers
* ST\_Buffer\_Strategy
* ST\_Collect
* ST\_FrechetDistance
* ST\_GeoHash
* ST\_GeomCollFromTxt
* ST\_HausdorffDistance
* ST\_IsValid
* ST\_LatFromGeoHash
* ST\_Latitude
* ST\_LineInterpolatePoint
* ST\_LineInterpolatePoints
* ST\_LongFromGeoHash
* ST\_Longitude
* ST\_MakeEnvelope
* ST\_NumInteriorRing
* ST\_PointAtDistance
* ST\_PointFromGeoHash
* ST\_Simplify
* ST\_SwapXY
* ST\_Transform
* ST\_Validate ([MDEV-17398](https://jira.mariadb.org/browse/MDEV-17398))

### JSON

* JSON\_SCHEMA\_VALIDATION\_REPORT
* JSON\_STORAGE\_FREE
* JSON\_STORAGE\_SIZE ([MDEV-17397](https://jira.mariadb.org/browse/MDEV-17397))
* MEMBER\_OF operator

### Regular Expressions

* REGEXP\_LIKE ([MDEV-16599](https://jira.mariadb.org/browse/MDEV-16599))

### UUID

* BIN\_TO\_UUID
* IS\_UUID
* UUID\_TO\_BIN ([MDEV-15854](https://jira.mariadb.org/browse/MDEV-15854))

### Miscellaneous

* ANY\_VALUE ([MDEV-10426](https://jira.mariadb.org/browse/MDEV-10426))
* ASYNCHRONOUS\_CONNECTION\_FAILOVER\_ADD\_SOURCE
* ASYNCHRONOUS\_CONNECTION\_FAILOVER\_DELETE\_SOURCE
* FORMAT\_BYTES ([MDEV-19629](https://jira.mariadb.org/browse/MDEV-19629))
* GROUPING ([MDEV-32789](https://jira.mariadb.org/browse/MDEV-32789))
* PS\_THREAD\_ID ([MDEV-19629](https://jira.mariadb.org/browse/MDEV-19629))
* PS\_CURRENT\_THREAD\_ID
* SOURCE\_POS\_WAIT
* VALIDATE\_PASSWORD\_STRENGTH ([MDEV-25703](https://jira.mariadb.org/browse/MDEV-25703))

## See Also

* [Incompatibilities and Feature Differences Between MariaDB 11.2 and MySQL 8.0](https://mariadb.com/docs/server/editions-and-compatibility/comparisons-with-other-databases/incompatibilities-and-feature-differences-between-mariadb-and-mysql-unmaint/incompatibilities-and-feature-differences-between-mariadb-11-2-and-mysql-8.md)
* [Function Differences Between MariaDB 11.1 and MySQL 8.0](https://mariadb.com/docs/server/editions-and-compatibility/comparisons-with-other-databases/function-differences-between-mariadb-and-mysql/function-differences-between-mariadb-and-mysql-unmaintained-series/function-differences-between-mariadb-11-1-and-mysql-8-0.md)
* [System Variable Differences Between MariaDB 11.2 and MySQL 8.0](https://mariadb.com/docs/server/editions-and-compatibility/comparisons-with-other-databases/system-variable-differences-between-mariadb-and-mysql/system-variable-differences-between-mariadb-and-mysql-unmaintained-series/system-variable-differences-between-mariadb-11-2-and-mysql-8-0.md)
* [MariaDB versus MySQL - Compatibility](https://mariadb.com/docs/server/editions-and-compatibility/comparisons-with-other-databases/mariadb-vs-mysql-compatibility.md)
* [MariaDB versus MySQL - Features](https://mariadb.com/docs/server/editions-and-compatibility/comparisons-with-other-databases/mariadb-vs-mysql-features.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formid="4316" formId="4316" %}
