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:
Category:MySQL Server: JSON User-defined function ( UDF ) Severity:S4 (Feature request)
Version:0.2 OS:Any
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D5 (Feature request) / R3 (Medium) / E3 (Medium)

[11 Oct 2013 19:26] Sveta Smirnova
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.
[19 Mar 2014 20:08] Sveta Smirnova
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.