[MDEV-12400] Implement stored procedure output parameter result set for the text protocol Created: 2017-03-29  Updated: 2017-04-20

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

Type: Task Priority: Major
Reporter: Vladislav Vaintroub Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: None


 Description   

diego dupin complains :

"big problem of text protocol is it hasn't output parameter resultset (i've tryed to implement that myself but without success. i'm still too bad in c
goal is to send command CALL sp(1, 3) for example, and have all output parameters has a resultset, exactly like for binary protocol when capability SERVER_PS_OUT_PARAMS is set, without variables"

Is there a sound technical reason why this feature is tied to server-side prepared statements? I do not seem to find any.

 Comments   
Comment by Vladislav Vaintroub [ 2017-03-29 ]

I personally would not like to add more own bits to the protocol, but control the output via session variable @@enable_sp_out_params_text, or similar with the default off for backwards compatibility. Alternatively, one can create output result set,whenever out/inout paramete is passed by- value (number, string constant, NULL, whatever), rather than by-reference, e.g as @@sessionvariable

Generated at Thu Feb 08 07:57:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.