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

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

How to repeat:
n/a

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] Shane Bester
bug #66981 may be a duplicate