SQLines tools can help you assess and convert database schema (DDL), queries and SQL scripts for MySQL to MariaDB migration.
Databases:
Operators:
MySQL | MariaDB | |||
1 | col->"$.path" | Extract JSON value | Not supported | |
2 | col->>"$.path" | Extract JSON value and unquote | Not supported |
JSON data:
MySQL | MariaDB | |||
1 | JSON | JSON data | LONGTEXT | JSON is an alias for LONGTEXT, can be used in CREATE TABLE |
Regular expression functions:
MySQL | MariaDB | ||
1 | REGEXP_LIKE(str, pattern [,mode]) | Check for common JSON keys in json1 and json2 | Not supported |
JSON functions:
JSON expressions:
MySQL | MariaDB | ||
1 | CAST('null' AS JSON) | Null JSON document | Not allowed, requires CAST('null' AS LONGTEXT) |
UUID functions:
Spatial functions:
Replication related functions:
Miscellaneous functions:
Converting SQL SELECT statement:
MySQL | MariaDB | ||
1 | /*+ MAX_EXECUTION_TIME(n) */ | Max execution time in milliseconds, query hint | Not supported |
Converting SQL statements:
MySQL | MariaDB | ||
1 | CREATE TABLESPACE name … | Create a tablespace | Not supported |
2 | CREATE USER name … | Create an user | CREATE USER name … see notes below |
CREATE USER statement:
MySQL | MariaDB | ||
1 | IDENTIFIED WITH mysql_native_password | User authentication plugin | Not supported |
IDENTIFIED WITH caching_sha2_password |