All pages
Powered by GitBook
1 of 20

Function Differences Between MariaDB and MySQL

Functions in MariaDB that are not present in MySQL, or vice-versa

Function Differences Between MariaDB Rolling and MySQL 8.0

The following is a list of all function differences between MariaDB 11.8 Rolling Release, and MySQL 8.0. It is based on functions available in the MySQL 8.0.39 and the MariaDB 11.8.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

  • 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

  • [Incompatibilities and Feature Differences Between MariaDB Rolling and MySQL 8.0](Incompatibilities and Feature Differences Between MariaDB Rolling and MySQL 8.0)

  • 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

Function Differences Between MariaDB 11.4 and MySQL 8.0

The following is a list of all function differences between MariaDB 11.4 and MySQL 8.0. It is based on functions available in the MySQL 8.0.36 and the MariaDB 11.4.1 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 11.4 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

  • 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* GeomCollection

  • ST_GeomCollFromTxt

  • ST_NumInteriorRing

  • 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

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_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)

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

  • Incompatibilities and Feature Differences Between MariaDB 11.4 and MySQL 8.0

  • Function Differences Between MariaDB 11.3 and MySQL 8.0

  • System Variable Differences Between MariaDB 11.4 and MySQL 8.0

  • MariaDB versus MySQL - Compatibility

  • MariaDB versus MySQL - Features

Function Differences Between MariaDB 10.11 and MySQL 8.0

The following is a list of all function differences between MariaDB 10.11 and MySQL 8.0. It is based on functions available in the MySQL 8.0.32 and the MariaDB 10.11.2 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 10.11 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

  • ADD_MONTHS

  • CHR

  • DECODE_ORACLE

  • DES_DECRYPT

  • DES_ENCRYPT

  • 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_COMPACT

  • JSON_DETAILED

  • JSON_EQUALS

  • JSON_EXISTS

  • JSON_LOOSE

  • JSON_NORMALIZE

  • JSON_QUERY

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_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)

JSON

  • JSON_SCHEMA_VALID (MDEV-27128)

  • 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)

  • FORMAT_PICO_TIME (MDEV-19629)

  • GROUPING (MDEV-32789)

  • PS_THREAD_ID (MDEV-19629)

  • PS_CURRENT_THREAD_ID

  • SOURCE_POS_WAIT

  • VALIDATE_PASSWORD_STRENGTH (MDEV-25703)

See Also

  • Incompatibilities and Feature Differences Between MariaDB 10.11 and MySQL 8.0

  • Function Differences Between MariaDB 10.10 and MySQL 8.0

  • System Variable Differences Between MariaDB 10.11 and MySQL 8.0

  • MariaDB versus MySQL - Compatibility

  • MariaDB versus MySQL - Features

Function Differences Between MariaDB 10.6 and MySQL 8.0

The following is a list of all function differences between MariaDB 10.6 and MySQL 8.0. It is based on functions available in the MySQL 8.0.23 and the MariaDB 10.6.12 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 10.6 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

  • ADD_MONTHS

  • CHR

  • DECODE_ORACLE

  • DES_DECRYPT

  • DES_ENCRYPT

  • LENGTHB

  • NVL (Synonym for IFNULL)

  • NVL2

  • 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_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_FrechetDistance

  • ST_GeoHash

  • ST_GeomCollFromTxt

  • ST_HausdorffDistance

  • ST_IsValid

  • ST_LatFromGeoHash

  • ST_Latitude

  • ST_LongFromGeoHash

  • ST_Longitude

  • ST_MakeEnvelope

  • ST_NumInteriorRing

  • ST_PointFromGeoHash

  • ST_Simplify

  • ST_SwapXY

  • ST_Transform

  • ST_Validate (MDEV-17398)

JSON

  • JSON_OVERLAPS (MDEV-27677)

  • JSON_SCHEMA_VALID (MDEV-27128)

  • 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)

  • FORMAT_PICO_TIME (MDEV-19629)

  • GROUPING (MDEV-32789)

  • PS_THREAD_ID (MDEV-19629)

  • PS_CURRENT_THREAD_ID

  • RANDOM_BYTES (MDEV-25704)

  • VALIDATE_PASSWORD_STRENGTH (MDEV-25703)

See Also

  • Incompatibilities and Feature Differences Between MariaDB 10.6 and MySQL 8.0

  • Function Differences Between MariaDB 10.5 and MySQL 8.0

  • Function Differences Between MariaDB 10.4 and MySQL 8.0

  • System Variable Differences Between MariaDB 10.6 and MySQL 8.0

  • MariaDB versus MySQL - Compatibility

  • MariaDB versus MySQL - Features

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

Function Differences Between MariaDB and MySQL - Unmaintained Series

The following articles list the differences between functions in MariaDB and in MySQL for each of the major MariaDB series that are no longer maintained

Function Differences Between MariaDB 10.10 and MySQL 8.0

The following is a list of all function differences between MariaDB 10.10 and MySQL 8.0. It is based on functions available in the MySQL 8.0.32 and the MariaDB 10.10.3 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 10.10 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

  • ADD_MONTHS

  • CHR

  • DECODE_ORACLE

  • DES_DECRYPT

  • DES_ENCRYPT

  • LENGTHB

  • NATURAL_SORT_KEY

  • NVL (Synonym for IFNULL)

  • SFORMAT

  • 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_COMPACT

  • JSON_DETAILED

  • JSON_EQUALS

  • JSON_EXISTS

  • JSON_LOOSE

  • JSON_NORMALIZE

  • JSON_QUERY

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

  • MBRCOVEREDBY

  • MBRCovers

  • ST_BUFFER_STRATEGY

  • ST_Collect

  • ST_FrechetDistance

  • ST_GeoHash

  • ST_HausdorffDistance

  • ST_IsValid

  • ST_LatFromGeoHash

  • ST_Latitude

  • ST_LineInterpolatePoint

  • ST_LineInterpolatePoints

  • ST_LongFromGeoHash

  • ST_Longitude

  • ST_MakeEnvelope

  • ST_PointAtDistance

  • ST_PointFromGeoHash

  • ST_SIMPLIFY

  • ST_TRANSFORM

  • ST_VALIDATE (MDEV-17398)

JSON

  • JSON_SCHEMA_VALID (MDEV-27128)

  • 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)

  • FORMAT_PICO_TIME (MDEV-19629)

  • GROUPING (MDEV-32789)

  • PS_THREAD_ID (MDEV-19629)

  • PS_CURRENT_THREAD_ID

  • VALIDATE_PASSWORD_STRENGTH (MDEV-25703)

See Also

  • Incompatibilities and Feature Differences Between MariaDB 10.10 and MySQL 8.0

  • Function Differences Between MariaDB 10.9 and MySQL 8.0

  • Function Differences Between MariaDB 10.8 and MySQL 8.0

  • System Variable Differences Between MariaDB 10.10 and MySQL 8.0

  • MariaDB versus MySQL - Compatibility

  • MariaDB versus MySQL - Features

Function Differences Between MariaDB 10.3 and MySQL 8.0

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

  • 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

  • MBRCOVEREDBY

  • MBRCovers

  • ST_BUFFER_STRATEGY

  • ST_GeoHash

  • ST_IsValid

  • ST_LatFromGeoHash

  • ST_LongFromGeoHash

  • ST_MakeEnvelope

  • 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

  • Function Differences Between MariaDB 10.3 and MySQL 5.7

  • System Variable Differences Between MariaDB 10.3 and MySQL 8.0

  • MariaDB versus MySQL - Compatibility

  • MariaDB versus MySQL - Features

Function Differences Between MariaDB 10.4 and MySQL 8.0

The following is a list of all function differences between MariaDB 10.4 and MySQL 8.0. It is based on functions available in the stable MySQL 8.0.17 and MariaDB 10.4.28 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 10.4 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

  • MBRCOVEREDBY

  • MBRCovers

  • ST_BUFFER_STRATEGY

  • ST_GeoHash

  • ST_IsValid

  • ST_LatFromGeoHash

  • ST_Latitude

  • ST_LongFromGeoHash

  • ST_Longitude

  • ST_MakeEnvelope

  • ST_PointFromGeoHash

  • ST_SIMPLIFY

  • ST_TRANSFORM

  • ST_VALIDATE

JSON

  • JSON_ARRAYAGG

  • JSON_OBJECTAGG

  • 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

  • RELEASE_ALL_LOCKS

  • VALIDATE_PASSWORD_STRENGTH

See Also

  • Incompatibilities and Feature Differences Between MariaDB 10.4 and MySQL 8.0

  • Function Differences Between MariaDB 10.3 and MySQL 8.0

  • Function Differences Between MariaDB 10.3 and MySQL 5.7

  • System Variable Differences Between MariaDB 10.4 and MySQL 8.0

  • MariaDB versus MySQL - Compatibility

  • MariaDB versus MySQL - Features

Function Differences Between MariaDB 10.7 and MySQL 8.0

The following is a list of all function differences between MariaDB 10.7 and MySQL 8.0. It is based on functions available in the MySQL 8.0.23 and the MariaDB 10.7.8 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 10.7 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

  • ADD_MONTHS

  • CHR

  • DECODE_ORACLE

  • DES_DECRYPT

  • DES_ENCRYPT

  • 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_COMPACT

  • JSON_DETAILED

  • JSON_EQUALS

  • JSON_EXISTS

  • JSON_LOOSE

  • JSON_NORMALIZE

  • JSON_QUERY

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

  • MBRCOVEREDBY

  • MBRCovers

  • ST_BUFFER_STRATEGY

  • ST_FrechetDistance

  • ST_GeoHash

  • ST_HausdorffDistance

  • ST_IsValid

  • ST_LatFromGeoHash

  • ST_Latitude

  • ST_LongFromGeoHash

  • ST_Longitude

  • ST_MakeEnvelope

  • ST_PointFromGeoHash

  • ST_SIMPLIFY

  • ST_TRANSFORM

  • ST_VALIDATE (MDEV-17398)

JSON

  • JSON_OVERLAPS (MDEV-27677)

  • JSON_SCHEMA_VALID (MDEV-27128)

  • 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)

  • FORMAT_PICO_TIME (MDEV-19629)

  • GROUPING

  • PS_THREAD_ID (MDEV-19629)

  • PS_CURRENT_THREAD_ID

  • RANDOM_BYTES (MDEV-25704)

  • VALIDATE_PASSWORD_STRENGTH (MDEV-25703)

See Also

  • Incompatibilities and Feature Differences Between MariaDB 10.7 and MySQL 8.0

  • Function Differences Between MariaDB 10.6 and MySQL 8.0

  • Function Differences Between MariaDB 10.5 and MySQL 8.0

  • System Variable Differences Between MariaDB 10.7 and MySQL 8.0

  • MariaDB versus MySQL - Compatibility

  • MariaDB versus MySQL - Features

Function Differences Between MariaDB 10.8 and MySQL 8.0

The following is a list of all function differences between MariaDB 10.8 and MySQL 8.0. It is based on functions available in the MySQL 8.0.23 and the MariaDB 10.8.7 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 10.8 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

  • ADD_MONTHS

  • CHR

  • DECODE_ORACLE

  • DES_DECRYPT

  • DES_ENCRYPT

  • 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_COMPACT

  • JSON_DETAILED

  • JSON_EQUALS

  • JSON_EXISTS

  • JSON_LOOSE

  • JSON_NORMALIZE

  • JSON_QUERY

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

  • MBRCOVEREDBY

  • MBRCovers

  • ST_BUFFER_STRATEGY

  • ST_FrechetDistance

  • ST_GeoHash

  • ST_HausdorffDistance

  • ST_IsValid

  • ST_LatFromGeoHash

  • ST_Latitude

  • ST_LongFromGeoHash

  • ST_Longitude

  • ST_MakeEnvelope

  • ST_PointFromGeoHash

  • ST_SIMPLIFY

  • ST_TRANSFORM

  • ST_VALIDATE (MDEV-17398)

JSON

  • JSON_OVERLAPS (MDEV-27677)

  • JSON_SCHEMA_VALID (MDEV-27128)

  • 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)

  • FORMAT_PICO_TIME (MDEV-19629)

  • GROUPING (MDEV-32789)

  • PS_THREAD_ID (MDEV-19629)

  • PS_CURRENT_THREAD_ID

  • RANDOM_BYTES (MDEV-25704)

  • VALIDATE_PASSWORD_STRENGTH (MDEV-25703)

See Also

  • Incompatibilities and Feature Differences Between MariaDB 10.7 and MySQL 8.0

  • Function Differences Between MariaDB 10.7 and MySQL 8.0

  • Function Differences Between MariaDB 10.6 and MySQL 8.0

  • System Variable Differences Between MariaDB 10.8 and MySQL 8.0

  • MariaDB versus MySQL - Compatibility

  • MariaDB versus MySQL - Features

Function Differences Between MariaDB 10.9 and MySQL 8.0

The following is a list of all function differences between MariaDB 10.9 and MySQL 8.0. It is based on functions available in the MySQL 8.0.24 and the MariaDB 10.9.5 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 10.9 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

  • ADD_MONTHS

  • CHR

  • DECODE_ORACLE

  • DES_DECRYPT

  • DES_ENCRYPT

  • 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_COMPACT

  • JSON_DETAILED

  • JSON_EQUALS

  • JSON_EXISTS

  • JSON_LOOSE

  • JSON_NORMALIZE

  • JSON_QUERY

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

  • MBRCOVEREDBY

  • MBRCovers

  • ST_BUFFER_STRATEGY

  • ST_Collect

  • ST_FrechetDistance

  • ST_GeoHash

  • ST_HausdorffDistance

  • ST_IsValid

  • ST_LatFromGeoHash

  • ST_Latitude

  • ST_LineInterpolatePoint

  • ST_LineInterpolatePoints

  • ST_LongFromGeoHash

  • ST_Longitude

  • ST_MakeEnvelope

  • ST_PointAtDistance

  • ST_PointFromGeoHash

  • ST_SIMPLIFY

  • ST_TRANSFORM

  • ST_VALIDATE (MDEV-17398)

JSON

  • JSON_SCHEMA_VALID (MDEV-27128)

  • 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)

  • FORMAT_PICO_TIME (MDEV-19629)

  • GROUPING (MDEV-32789)

  • PS_THREAD_ID (MDEV-19629)

  • PS_CURRENT_THREAD_ID

  • RANDOM_BYTES (MDEV-25704)

  • VALIDATE_PASSWORD_STRENGTH (MDEV-25703)

See Also

  • Incompatibilities and Feature Differences Between MariaDB 10.9 and MySQL 8.0

  • Function Differences Between MariaDB 10.8 and MySQL 8.0

  • Function Differences Between MariaDB 10.7 and MySQL 8.0

  • System Variable Differences Between MariaDB 10.9 and MySQL 8.0

  • MariaDB versus MySQL - Compatibility

  • MariaDB versus MySQL - Features

Function Differences Between MariaDB 10.2 and MySQL 5.6

The following is a list of all function differences between MariaDB 10.2 and MySQL 5.6. It is based on functions available in the stable version MariaDB 10.2.25.

Present in MariaDB Only

Dynamic Columns

  • COLUMN_ADD

  • COLUMN_CHECK

  • COLUMN_CREATE

  • COLUMN_DELETE

  • COLUMN_EXISTS

  • COLUMN_GET

  • COLUMN_JSON

  • COLUMN_LIST

JSON

  • JSON_ARRAY

  • JSON_ARRAY_APPEND

  • JSON_ARRAY_INSERT

  • JSON_COMPACT

  • JSON_CONTAINS

  • JSON_CONTAINS_PATH

  • JSON_DEPTH

  • JSON_DETAILED

  • JSON_EXISTS

  • JSON_EXTRACT

  • JSON_INSERT

  • JSON_KEYS

  • JSON_LENGTH

  • JSON_LOOSE

  • JSON_MERGE

  • JSON_MERGE_PATCH

  • JSON_MERGE_PRESERVE

  • JSON_OBJECT

  • JSON_QUERY

  • JSON_QUOTE

  • JSON_REMOVE

  • JSON_REPLACE

  • JSON_SEARCH

  • JSON_SET

  • JSON_TYPE

  • JSON_UNQUOTE

  • JSON_VALID

  • JSON_VALUE

Regular Expressions

  • REGEXP_INSTR

  • REGEXP_REPLACE

  • REGEXP_SUBSTR

Window Functions

  • CUME_DIST

  • DENSE_RANK

  • LAG

  • LAST_VALUE

  • LEAD

  • NTH_VALUE

  • NTILE

  • PERCENT_RANK

  • RANK

  • ROW_NUMBER

Present in MySQL Only

GTID

MariaDB and MySQL have differing GTID implementations.

  • GTID_SUBSET

  • GTID_SUBTRACT

  • SQL_THREAD_WAIT_AFTER_GTIDS()

  • WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()

Miscellaneous

  • RANDOM_BYTES

  • VALIDATE_PASSWORD_STRENGTH

See Also

  • Function Differences Between MariaDB 10.2 and MySQL 5.7

  • System Variable Differences Between MariaDB 10.2 and MySQL 5.6

  • MariaDB versus MySQL - Compatibility

  • MariaDB versus MySQL - Features

Function Differences Between MariaDB 10.2 and MySQL 5.7

The following is a list of all function differences between MariaDB 10.2 and MySQL 5.7. It is based on functions available in the stable versions MySQL 5.7.18 and MariaDB 10.2.38.

For a description of all differences, see Incompatibilities and Feature Differences Between MariaDB 10.2 and MySQL 5.7.

Present in MariaDB Only

Dynamic columns

  • COLUMN_ADD

  • COLUMN_CHECK

  • COLUMN_CREATE

  • COLUMN_DELETE

  • COLUMN_EXISTS

  • COLUMN_GET

  • COLUMN_JSON

  • COLUMN_LIST

JSON

  • JSON_COMPACT

  • JSON_DETAILED

  • JSON_EXISTS

  • JSON_LOOSE

  • JSON_MERGE_PATCH

  • JSON_MERGE_PRESERVE

  • JSON_QUERY

  • JSON_VALUE

Regular Expressions

  • REGEXP_INSTR

  • REGEXP_REPLACE

  • REGEXP_SUBSTR

Window Functions

  • CUME_DIST

  • DENSE_RANK

  • LAG

  • LAST_VALUE

  • LEAD

  • NTH_VALUE

  • NTILE

  • PERCENT_RANK

  • RANK

  • ROW_NUMBER

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

  • DISTANCE

  • MBRCOVEREDBY

  • ST_BUFFER_STRATEGY

  • ST_GeoHash

  • ST_IsValid

  • ST_LatFromGeoHash

  • ST_LongFromGeoHash

  • ST_PointFromGeoHash

  • ST_SIMPLIFY

  • ST_VALIDATE

Miscellaneous

  • ANY_VALUE

  • RANDOM_BYTES

  • RELEASE_ALL_LOCKS

  • VALIDATE_PASSWORD_STRENGTH

See Also

  • Incompatibilities and Feature Differences Between MariaDB 10.2 and MySQL 5.7

  • System Variable Differences Between MariaDB 10.2 and MySQL 5.7

  • Function Differences Between MariaDB 10.3 and MySQL 5.7

  • Function Differences Between MariaDB 10.2 and MySQL 5.6

Function Differences Between MariaDB 10.3 and MySQL 5.7

The following is a list of all function differences between MariaDB 10.3 and MySQL 5.7. It is based on functions available in the stable versions MySQL 5.7.18 and MariaDB 10.3.29.

For a description of all differences, see Incompatibilities and Feature Differences Between MariaDB 10.3 and MySQL 5.7.

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

  • LENGTHB

  • NVL (Synonym for IFNULL)

  • NVL2

  • TRIM_ORACLE

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

JSON

  • JSON_COMPACT

  • JSON_DETAILED

  • JSON_EXISTS

  • JSON_LOOSE

  • JSON_MERGE_PATCH

  • JSON_MERGE_PRESERVE

  • JSON_QUERY

  • JSON_VALUE

Regular Expressions

  • REGEXP_INSTR

  • REGEXP_REPLACE

  • REGEXP_SUBSTR

Sequences

  • LASTVAL

  • NEXTVAL

  • SETVAL

Window Functions

  • CUME_DIST

  • DENSE_RANK

  • LAG

  • LAST_VALUE

  • LEAD

  • MEDIAN

  • NTH_VALUE

  • NTILE

  • PERCENT_RANK

  • PERCENTILE_CONT

  • PERCENTILE_DISC

  • RANK

  • ROW_NUMBER

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

  • DISTANCE

  • MBRCOVEREDBY

  • ST_BUFFER_STRATEGY

  • ST_GeoHash

  • ST_IsValid

  • ST_LatFromGeoHash

  • ST_LongFromGeoHash

  • ST_PointFromGeoHash

  • ST_SIMPLIFY

  • ST_VALIDATE

Miscellaneous

  • ANY_VALUE

  • RANDOM_BYTES

  • RELEASE_ALL_LOCKS

  • VALIDATE_PASSWORD_STRENGTH

See Also

  • Incompatibilities and Feature Differences Between MariaDB 10.3 and MySQL 5.7

  • System Variable Differences Between MariaDB 10.3 and MySQL 5.7

  • Function Differences Between MariaDB 10.2 and MySQL 5.7

Function Differences Between MariaDB 11.0 and MySQL 8.0

The following is a list of all function differences between MariaDB 11.0 and MySQL 8.0. It is based on functions available in the MySQL 8.0.34 and the MariaDB 11.0.2 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 11.0 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

  • ADD_MONTHS

  • CHR

  • DECODE_ORACLE

  • DES_DECRYPT

  • DES_ENCRYPT

  • 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_COMPACT

  • JSON_DETAILED

  • JSON_EQUALS

  • JSON_EXISTS

  • JSON_LOOSE

  • JSON_NORMALIZE

  • JSON_QUERY

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

  • MBRCOVEREDBY

  • MBRCovers

  • ST_BUFFER_STRATEGY

  • ST_Collect

  • ST_FrechetDistance

  • ST_GeoHash

  • ST_HausdorffDistance

  • ST_IsValid

  • ST_LatFromGeoHash

  • ST_Latitude

  • ST_LineInterpolatePoint

  • ST_LineInterpolatePoints

  • ST_LongFromGeoHash

  • ST_Longitude

  • ST_MakeEnvelope

  • ST_PointAtDistance

  • ST_PointFromGeoHash

  • ST_SIMPLIFY

  • ST_VALIDATE (MDEV-17398)

JSON

  • JSON_SCHEMA_VALID (MDEV-27128)

  • 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

  • Incompatibilities and Feature Differences Between MariaDB 11.0 and MySQL 8.0

  • Function Differences Between MariaDB 10.11 and MySQL 8.0

  • System Variable Differences Between MariaDB 11.0 and MySQL 8.0

  • MariaDB versus MySQL - Compatibility

  • MariaDB versus MySQL - Features

Function Differences Between MariaDB 11.1 and MySQL 8.0

The following is a list of all function differences between MariaDB 11.1 and MySQL 8.0. It is based on functions available in the MySQL 8.0.34 and the MariaDB 11.1.1 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 11.1 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

  • ADD_MONTHS

  • CHR

  • DECODE_ORACLE

  • DES_DECRYPT

  • DES_ENCRYPT

  • 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_COMPACT

  • JSON_DETAILED

  • JSON_EQUALS

  • JSON_EXISTS

  • JSON_LOOSE

  • JSON_NORMALIZE

  • JSON_QUERY

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

  • MBRCOVEREDBY

  • MBRCovers

  • ST_BUFFER_STRATEGY

  • ST_Collect

  • ST_FrechetDistance

  • ST_GeoHash

  • ST_HausdorffDistance

  • ST_IsValid

  • ST_LatFromGeoHash

  • ST_Latitude

  • ST_LineInterpolatePoint

  • ST_LineInterpolatePoints

  • ST_LongFromGeoHash

  • ST_Longitude

  • ST_MakeEnvelope

  • ST_PointAtDistance

  • ST_PointFromGeoHash

  • ST_SIMPLIFY

  • ST_VALIDATE (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

  • Incompatibilities and Feature Differences Between MariaDB 11.1 and MySQL 8.0

  • Function Differences Between MariaDB 11.0 and MySQL 8.0

  • System Variable Differences Between MariaDB 11.1 and MySQL 8.0

  • MariaDB versus MySQL - Compatibility

  • MariaDB versus MySQL - Features

Function Differences Between MariaDB 11.2 and MySQL 8.0

The following is a list of all function differences between MariaDB 11.2 and MySQL 8.0. It is based on functions available in the MySQL 8.0.34 and the MariaDB 11.2.1 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 11.2 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

  • ADD_MONTHS

  • CHR

  • DECODE_ORACLE

  • DES_DECRYPT

  • DES_ENCRYPT

  • 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

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_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)

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

  • Incompatibilities and Feature Differences Between MariaDB 11.2 and MySQL 8.0

  • Function Differences Between MariaDB 11.1 and MySQL 8.0

  • System Variable Differences Between MariaDB 11.2 and MySQL 8.0

  • MariaDB versus MySQL - Compatibility

  • MariaDB versus MySQL - Features

Function Differences Between MariaDB 11.3 and MySQL 8.0

The following is a list of all function differences between MariaDB 11.3 and MySQL 8.0. It is based on functions available in the MySQL 8.0.35 and the MariaDB 11.3.1 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 11.3 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

  • 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_LOOSE

  • JSON_NORMALIZE

  • JSON_OBJECT_FILTER_KEYS

  • JSON_OBJECT_TO_ARRAY

  • JSON_QUERY

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

  • MBRCOVEREDBY

  • MBRCovers

  • ST_BUFFER_STRATEGY

  • ST_Collect

  • ST_FrechetDistance

  • ST_GeoHash

  • ST_HausdorffDistance

  • ST_IsValid

  • ST_LatFromGeoHash

  • ST_Latitude

  • ST_LineInterpolatePoint

  • ST_LineInterpolatePoints

  • ST_LongFromGeoHash

  • ST_Longitude

  • ST_MakeEnvelope

  • ST_PointAtDistance

  • ST_PointFromGeoHash

  • ST_SIMPLIFY

  • ST_VALIDATE (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

  • Incompatibilities and Feature Differences Between MariaDB 11.3 and MySQL 8.0

  • Function Differences Between MariaDB 11.2 and MySQL 8.0

  • System Variable Differences Between MariaDB 11.3 and MySQL 8.0

  • MariaDB versus MySQL - Compatibility

  • MariaDB versus MySQL - Features