Functions in MariaDB that are not present in MySQL, or vice-versa
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
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS
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_SCHEMA_VALIDATION_REPORT
JSON_STORAGE_FREE
JSON_STORAGE_SIZE (MDEV-17397)
MEMBER_OF operator
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN (MDEV-15854)
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)
[Incompatibilities and Feature Differences Between MariaDB Rolling and MySQL 8.0](Incompatibilities and Feature Differences Between MariaDB Rolling 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
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MultiPointFromText* GeomCollection
ST_GeomCollFromTxt
ST_NumInteriorRing
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS
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_SCHEMA_VALIDATION_REPORT
JSON_STORAGE_FREE
JSON_STORAGE_SIZE (MDEV-17397)
MEMBER_OF operator
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN (MDEV-15854)
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)
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
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS
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_SCHEMA_VALID (MDEV-27128)
JSON_SCHEMA_VALIDATION_REPORT
JSON_STORAGE_FREE
JSON_STORAGE_SIZE (MDEV-17397)
MEMBER_OF operator
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN (MDEV-15854)
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)
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
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS
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_OVERLAPS (MDEV-27677)
JSON_SCHEMA_VALID (MDEV-27128)
JSON_SCHEMA_VALIDATION_REPORT
JSON_STORAGE_FREE
JSON_STORAGE_SIZE (MDEV-17397)
MEMBER_OF operator
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN (MDEV-15854)
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)
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
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()
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_OVERLAPS
JSON_SCHEMA_VALID (MDEV-27128)
JSON_SCHEMA_VALIDATION_REPORT
JSON_STORAGE_FREE
JSON_STORAGE_SIZE (MDEV-17397)
JSON_TABLE
MEMBER_OF operator
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN
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
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
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
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS
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_SCHEMA_VALID (MDEV-27128)
JSON_SCHEMA_VALIDATION_REPORT
JSON_STORAGE_FREE
JSON_STORAGE_SIZE (MDEV-17397)
MEMBER_OF operator
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN (MDEV-15854)
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)
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.
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()
MBRCOVEREDBY
MBRCovers
ST_BUFFER_STRATEGY
ST_GeoHash
ST_IsValid
ST_LatFromGeoHash
ST_LongFromGeoHash
ST_MakeEnvelope
ST_PointFromGeoHash
ST_SIMPLIFY
ST_VALIDATE
JSON_ARRAYAGG
JSON_OBJECTAGG
JSON_PRETTY
JSON_STORAGE_FREE
JSON_STORAGE_SIZE
JSON_TABLE
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN
ANY_VALUE
GROUPING
RANDOM_BYTES
RELEASE_ALL_LOCKS
VALIDATE_PASSWORD_STRENGTH
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.
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()
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_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
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN
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
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
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS
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_OVERLAPS (MDEV-27677)
JSON_SCHEMA_VALID (MDEV-27128)
JSON_SCHEMA_VALIDATION_REPORT
JSON_STORAGE_FREE
JSON_STORAGE_SIZE (MDEV-17397)
MEMBER_OF operator
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN (MDEV-15854)
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)
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
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS
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_OVERLAPS (MDEV-27677)
JSON_SCHEMA_VALID (MDEV-27128)
JSON_SCHEMA_VALIDATION_REPORT
JSON_STORAGE_FREE
JSON_STORAGE_SIZE (MDEV-17397)
MEMBER_OF operator
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN (MDEV-15854)
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)
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
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS
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_SCHEMA_VALID (MDEV-27128)
JSON_SCHEMA_VALIDATION_REPORT
JSON_STORAGE_FREE
JSON_STORAGE_SIZE (MDEV-17397)
MEMBER_OF operator
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN (MDEV-15854)
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)
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.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
SQL_THREAD_WAIT_AFTER_GTIDS()
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()
RANDOM_BYTES
VALIDATE_PASSWORD_STRENGTH
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.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()
DISTANCE
MBRCOVEREDBY
ST_BUFFER_STRATEGY
ST_GeoHash
ST_IsValid
ST_LatFromGeoHash
ST_LongFromGeoHash
ST_PointFromGeoHash
ST_SIMPLIFY
ST_VALIDATE
ANY_VALUE
RANDOM_BYTES
RELEASE_ALL_LOCKS
VALIDATE_PASSWORD_STRENGTH
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.
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()
DISTANCE
MBRCOVEREDBY
ST_BUFFER_STRATEGY
ST_GeoHash
ST_IsValid
ST_LatFromGeoHash
ST_LongFromGeoHash
ST_PointFromGeoHash
ST_SIMPLIFY
ST_VALIDATE
ANY_VALUE
RANDOM_BYTES
RELEASE_ALL_LOCKS
VALIDATE_PASSWORD_STRENGTH
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
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS
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_SCHEMA_VALID (MDEV-27128)
JSON_SCHEMA_VALIDATION_REPORT
JSON_STORAGE_FREE
JSON_STORAGE_SIZE (MDEV-17397)
MEMBER_OF operator
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN (MDEV-15854)
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)
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
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS
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_SCHEMA_VALIDATION_REPORT
JSON_STORAGE_FREE
JSON_STORAGE_SIZE (MDEV-17397)
MEMBER_OF operator
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN (MDEV-15854)
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)
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
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS
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_SCHEMA_VALIDATION_REPORT
JSON_STORAGE_FREE
JSON_STORAGE_SIZE (MDEV-17397)
MEMBER_OF operator
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN (MDEV-15854)
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)
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
NVL (Synonym for IFNULL)
VALUE - the VALUES() function was renamed after MariaDB introduced Table Value Constructors.
MySQL has removed the following functions in MySQL 8.0.
MariaDB and MySQL have differing GTID implementations.
GTID_SUBSET
GTID_SUBTRACT
WAIT_FOR_EXECUTED_GTID_SET
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS
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_SCHEMA_VALIDATION_REPORT
JSON_STORAGE_FREE
JSON_STORAGE_SIZE (MDEV-17397)
MEMBER_OF operator
REGEXP_LIKE (MDEV-16599)
BIN_TO_UUID
IS_UUID
UUID_TO_BIN (MDEV-15854)
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)