Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
Allow prepared statements, when executed, to output the fetched data into a JSON array of objects. For example
delimiter //
|
CREATE OR REPLACE PROCEDURE getjson(OUT ret JSON) |
BEGIN
|
DECLARE ret JSON; |
 |
PREPARE s1 FROM 'SELECT 57 c1 UNION SELECT 58 c1 UNION SELECT NULL c1'; |
EXECUTE s1 INTO JSON ret; |
END; |
//
|
CALL getjson(@r);
|
SELECT @r; |
[{"c1": 57}, {"c1": 58"},{"c1": null}] |