[MDEV-13313] JSON type alias is insufficiently compatible Created: 2017-07-13  Updated: 2017-09-27  Resolved: 2017-08-14

Status: Closed
Project: MariaDB Server
Component/s: Data types, JSON
Affects Version/s: 10.2.7
Fix Version/s: 10.2.8

Type: Bug Priority: Major
Reporter: Sergei Golubchik Assignee: Sergei Golubchik
Resolution: Fixed Votes: 1
Labels: None

Issue Links:
Relates
relates to MDEV-9144 JSON data type Closed
relates to MDEV-13916 Enforce check constraint on JSON type Closed

 Description   

Now it maps to TEXT. It'd be more compatible to map it to

  LONGTEXT CHARACTER SET utf8mb4 CHECK(JSON_VALID(col))

But auto-adding a constraint is questionable. An unexpected constraint in the table definition, performance implications, strange errors if one manually specifies some constraint for this column.


Generated at Thu Feb 08 08:04:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.