Bug #55308 JSON Object Support
Submitted: 16 Jul 2010 6:54
Reporter: Mikiya Okuno Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Data Types Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[16 Jul 2010 6:54] Mikiya Okuno
JSON is often used in the web applications today. Supporting JSON object inside MySQL will make many web developers happy :)

How to repeat:

Suggested fix:
- Add 'JSON' as a new data type
- Allow JSON columns to be indexed.
- If the column is indexed:
  * have a separate hidden column to store a value for a specified/indexed key
  * column data is parsed automatically when inserted/updated.

This implementation can be used with any storage engines. Not only MyISAM, but also InnoDB or even NDB.
[12 Feb 2013 18:33] MySQL Verification Team
bug #66981 may be a duplicate