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

Galera

General

Geographic

MySQL has removed the following functions in MySQL 8.0.

JSON

Sequences

Window Functions

Present in MySQL Only

GTID

MariaDB and MySQL have differing implementations.

• GTID_SUBSET

• GTID_SUBTRACT

• WAIT_FOR_EXECUTED_GTID_SET

• WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS

Geographic

• GeomCollection

• MBRCoveredBy

• MBRCovers

• ST_Buffer_Strategy

JSON

• JSON_SCHEMA_VALIDATION_REPORT

• JSON_STORAGE_FREE

• JSON_STORAGE_SIZE ()

• MEMBER_OF operator

Regular Expressions

• REGEXP_LIKE ()

UUID

• BIN_TO_UUID

• IS_UUID

• UUID_TO_BIN ()

Miscellaneous

• ANY_VALUE ()

• ASYNCHRONOUS_CONNECTION_FAILOVER_ADD_SOURCE

• ASYNCHRONOUS_CONNECTION_FAILOVER_DELETE_SOURCE

• FORMAT_BYTES ()

See Also

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

Galera

General

Geographic

MySQL has removed the following functions in MySQL 8.0.

JSON

Sequences

Window Functions

Present in MySQL Only

GTID

MariaDB and MySQL have differing implementations.

• GTID_SUBSET

• GTID_SUBTRACT

• WAIT_FOR_EXECUTED_GTID_SET

• WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS

Geographic

• MBRCOVEREDBY

• MBRCovers

• ST_BUFFER_STRATEGY

• ST_Collect

JSON

• JSON_SCHEMA_VALIDATION_REPORT

• JSON_STORAGE_FREE

• JSON_STORAGE_SIZE ()

• MEMBER_OF operator

Regular Expressions

• REGEXP_LIKE ()

UUID

• BIN_TO_UUID

• IS_UUID

• UUID_TO_BIN ()

Miscellaneous

• ANY_VALUE ()

• ASYNCHRONOUS_CONNECTION_FAILOVER_ADD_SOURCE

• ASYNCHRONOUS_CONNECTION_FAILOVER_DELETE_SOURCE

• FORMAT_BYTES ()

See Also

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

JSON

Regular Expressions

Window Functions

Present in MySQL Only

GTID

MariaDB and MySQL have differing implementations.

• GTID_SUBSET

• GTID_SUBTRACT

• WAIT_FOR_EXECUTED_GTID_SET

• WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()

Geographic

• DISTANCE

• MBRCOVEREDBY

• ST_BUFFER_STRATEGY

• ST_GeoHash

Miscellaneous

• ANY_VALUE

• RANDOM_BYTES

• RELEASE_ALL_LOCKS

• VALIDATE_PASSWORD_STRENGTH

See Also

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

General

• (Synonym for IFNULL)

JSON

Regular Expressions

Sequences

Window Functions

Present in MySQL Only

GTID

MariaDB and MySQL have differing implementations.

• GTID_SUBSET

• GTID_SUBTRACT

• WAIT_FOR_EXECUTED_GTID_SET

• WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()

Geographic

• DISTANCE

• MBRCOVEREDBY

• ST_BUFFER_STRATEGY

• ST_GeoHash

Miscellaneous

• ANY_VALUE

• RANDOM_BYTES

• RELEASE_ALL_LOCKS

• VALIDATE_PASSWORD_STRENGTH

See Also

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

JSON

Regular Expressions

Window Functions

Present in MySQL Only

GTID

MariaDB and MySQL have differing implementations.

• GTID_SUBSET

• GTID_SUBTRACT

• SQL_THREAD_WAIT_AFTER_GTIDS()

• WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()

Miscellaneous

• RANDOM_BYTES

• VALIDATE_PASSWORD_STRENGTH

See Also

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

Galera

General

Geographic

MySQL has removed the following functions in MySQL 8.0.

JSON

Sequences

Window Functions

Present in MySQL Only

GTID

MariaDB and MySQL have differing implementations.

• GTID_SUBSET

• GTID_SUBTRACT

• WAIT_FOR_EXECUTED_GTID_SET

• WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS

Geographic

• MBRCOVEREDBY

• MBRCovers

• ST_BUFFER_STRATEGY

• ST_Collect

JSON

• JSON_SCHEMA_VALID ()

• JSON_SCHEMA_VALIDATION_REPORT

• JSON_STORAGE_FREE

• JSON_STORAGE_SIZE ()

Regular Expressions

• REGEXP_LIKE ()

UUID

• BIN_TO_UUID

• IS_UUID

• UUID_TO_BIN ()

Miscellaneous

• ANY_VALUE ()

• ASYNCHRONOUS_CONNECTION_FAILOVER_ADD_SOURCE

• ASYNCHRONOUS_CONNECTION_FAILOVER_DELETE_SOURCE

• FORMAT_BYTES ()

See Also

The following is a list of all function differences between and MySQL 8.0. It is based on functions available in the stable MySQL 8.0.17 and releases. For a more complete list of differences, see .

Present in MariaDB Only

The following is a list of all function differences between and MySQL 8.0. It is based on functions available in the stable versions MySQL 8.0.11 and .

Present in MariaDB Only

Dynamic Columns

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

Galera

General

Geographic

MySQL has removed the following functions in MySQL 8.0.

JSON

Sequences

Window Functions

Present in MySQL Only

GTID

MariaDB and MySQL have differing implementations.

• GTID_SUBSET

• GTID_SUBTRACT

• WAIT_FOR_EXECUTED_GTID_SET

• WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS

Geographic

• MBRCOVEREDBY

• MBRCovers

• ST_BUFFER_STRATEGY

• ST_Collect

JSON

• JSON_SCHEMA_VALID ()

• JSON_SCHEMA_VALIDATION_REPORT

• JSON_STORAGE_FREE

• JSON_STORAGE_SIZE ()

Regular Expressions

• REGEXP_LIKE ()

UUID

• BIN_TO_UUID

• IS_UUID

• UUID_TO_BIN ()

Miscellaneous

• ANY_VALUE ()

• ASYNCHRONOUS_CONNECTION_FAILOVER_ADD_SOURCE

• ASYNCHRONOUS_CONNECTION_FAILOVER_DELETE_SOURCE

• FORMAT_BYTES ()

See Also

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

Galera

General

Geographic

MySQL has removed the following functions in MySQL 8.0.

JSON

Sequences

Window Functions

Present in MySQL Only

GTID

MariaDB and MySQL have differing implementations.

• GTID_SUBSET

• GTID_SUBTRACT

• WAIT_FOR_EXECUTED_GTID_SET

• WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS

Geographic

• MBRCOVEREDBY

• MBRCovers

• ST_BUFFER_STRATEGY

• ST_FrechetDistance

JSON

• JSON_OVERLAPS ()

• JSON_SCHEMA_VALID ()

• JSON_SCHEMA_VALIDATION_REPORT

• JSON_STORAGE_FREE

Regular Expressions

• REGEXP_LIKE ()

UUID

• BIN_TO_UUID

• IS_UUID

• UUID_TO_BIN ()

Miscellaneous

• ANY_VALUE ()

• ASYNCHRONOUS_CONNECTION_FAILOVER_ADD_SOURCE

• ASYNCHRONOUS_CONNECTION_FAILOVER_DELETE_SOURCE

• FORMAT_BYTES ()

See Also

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

Galera

General

Geographic

MySQL has removed the following functions in MySQL 8.0.

JSON

Sequences

Window Functions

Present in MySQL Only

GTID

MariaDB and MySQL have differing implementations.

• GTID_SUBSET

• GTID_SUBTRACT

• WAIT_FOR_EXECUTED_GTID_SET

• WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS

Geographic

• MBRCOVEREDBY

• MBRCovers

• ST_BUFFER_STRATEGY

• ST_Collect

JSON

• JSON_SCHEMA_VALIDATION_REPORT

• JSON_STORAGE_FREE

• JSON_STORAGE_SIZE ()

• MEMBER_OF operator

Regular Expressions

• REGEXP_LIKE ()

UUID

• BIN_TO_UUID

• IS_UUID

• UUID_TO_BIN ()

Miscellaneous

• ANY_VALUE ()

• ASYNCHRONOUS_CONNECTION_FAILOVER_ADD_SOURCE

• ASYNCHRONOUS_CONNECTION_FAILOVER_DELETE_SOURCE

• FORMAT_BYTES ()

See Also

The following is a list of all function differences between and MySQL 8.0. It is based on functions available in the MySQL 8.0.24 and the releases. For a more complete list of differences, see

Present in MariaDB Only

The following is a list of all function differences between and MySQL 8.0. It is based on functions available in the MySQL 8.0.23 and the releases. For a more complete list of differences, see

Present in MariaDB Only

The following is a list of all function differences between and MySQL 8.0. It is based on functions available in the MySQL 8.0.17 and the releases. For a more complete list of differences, see

Present in MariaDB Only