All pages
Powered by GitBook
1 of 1

Loading...

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

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

  • 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
    COLUMN_ADD
    COLUMN_CHECK
    COLUMN_CREATE
    COLUMN_DELETE
    JSON_ARRAY
    JSON_ARRAY_APPEND
    JSON_ARRAY_INSERT
    JSON_COMPACT
    REGEXP_INSTR
    REGEXP_REPLACE
    REGEXP_SUBSTR
    CUME_DIST
    DENSE_RANK
    LAG
    LAST_VALUE
    GTID
    COLUMN_EXISTS
    COLUMN_GET
    COLUMN_JSON
    COLUMN_LIST
    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
    LEAD
    NTH_VALUE
    NTILE
    PERCENT_RANK
    RANK
    ROW_NUMBER