Showing content from https://mariadb.com/kb/en/function-differences-between-mariadb-11-4-and-mysql-8-0/ below:
Function Differences Between MariaDB 11.4 and MySQL 8.0
Knowledge Base
»
Server & Client Software
»
MariaDB Releases
»
Compatibility & Differences
»
Function Differences Between MariaDB and MySQL
»
Function Differences Between MariaDB 11.4 and MySQL 8.0
History Source Flag as Spam / Inappropriate Translate
-
Created
-
1 year, 1 month ago
-
Modified
-
4 months, 2 weeks ago
-
Type
-
article
-
Status
-
active
-
License
-
CC BY-SA / Gnu FDL
Edit Attachments
No attachments exist
Function Differences Between MariaDB 11.4 and MySQL 8.0 Contents
- Present in MariaDB Only
- Dynamic Columns
- Galera
- General
- Geographic
- JSON
- Sequences
- Window Functions
- Present in MySQL Only
- GTID
- Geographic
- JSON
- Regular Expressions
- UUID
- Miscellaneous
- See Also
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
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 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
UUID
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
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
RetroSearch is an open source project built by @garambo
| Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.3