[MDEV-27249] Prepared statement EXECUTE into JSON support Created: 2021-12-13  Updated: 2021-12-13

Status: Open
Project: MariaDB Server
Component/s: Stored routines
Fix Version/s: None

Type: Task Priority: Major
Reporter: Anders Karlsson Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: 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}]


Generated at Thu Feb 08 09:51:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.