MySQL Bugs: #55308: JSON Object Support

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

bug #66981 may be a duplicate