MySQL Bugs: #70606: Implement SAFE versions for all JSON functions

Bug #70606	Implement SAFE versions for all JSON functions
Submitted:	11 Oct 2013 19:26	Modified:	19 Mar 2014 20:09
Reporter:	Sveta Smirnova	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: JSON User-defined function ( UDF )	Severity:	S4 (Feature request)
Version:	0.2	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Currently JSON functions do not check for validity. This is done for purpose to improve speed of functions. But in some situations people need to check for validity both parameters and returned result.

How to repeat:
See description

Suggested fix:
Check each argument which needs to be JSON document for validity. In addition, for functions which return JSON as a result, check the result too.

Posted by developer:
 
Actually due to internal design changes all functions, except JSON_MERGE, check documents for validity while proceed them. So this feature is already implemented.