I'm not sure if this is a bug of a documentation issue, but if I create a json ("JSON (stored as raw JSON in database)") field the table column is created as "longtext" in MariaDB. Shouldn't it be created as "json"?

CommentFileSizeAuthor
#6 json_field-n3314495-6.patch3.7 KBdamienmckenna

Comments

DamienMcKenna created an issue. See original summary.

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Component: Miscellaneous » Documentation
Category: Support request » Task

Looking at the MariaDB blog it seems that MariaDB uses LONGTEXT fields for storing the data; I'll have to test it with MySQL directly to confirm the behavior and then document it to avoid confusion.

damienmckenna’s picture

damienmckenna
Location TN, USA
commented

From alexpott: https://mariadb.com/kb/en/json-data-type/

JSON is an alias for LONGTEXT introduced for compatibility reasons with MySQL's JSON data type.

DamienMcKenna credited alexpott.

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Component: Documentation » User interface

This needs some clarification in the UI.

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Status: Active » Needs review
Related issues: +#3143512: Support JSON fields in MySQL schema
StatusFileSize
new json_field-n3314495-6.patch3.7 KB

Some changes to the UI and documentation improvements.

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Status: Needs review » Fixed

Committed.

  • DamienMcKenna committed fff0768 on 8.x-1.x 
    Issue #3314495 by DamienMcKenna, alexpott: Docs/UI improvements.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.