MYSQL_JSON

MariaDB starting with 10.5.7

The TYPE_MYSQL_JSON plugin was first released in MariaDB 10.5.7.

The JSON type in MySQL stores the JSON object in its own native form, while in MariaDB the JSON type is a LONGTEXT. Opening a table with a JSON type created in MySQL would result in an error:

select * from mysql_json_table;
ERROR 4161 (HY000): Unknown data type: 'MYSQL_JSON'

The mysql_json plugin is used to make it easier to upgrade to MariaDB.

Installing

Installing can be done in a number of ways, for example:

install soname 'type_mysql_json';

See Making MariaDB understand MySQL JSON for a full description.

_{This page is licensed: CC BY-SA / Gnu FDL}