Bug #115329 Internals manual for adding native functions not discussing JSON and table
Submitted: 14 Jun 2024 7:19 Modified: 14 Jun 2024 13:28
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Documentation Severity:S4 (Feature request)
Version:8.4.0 OS:Any
Assigned to: CPU Architecture:Any

[14 Jun 2024 7:19] Laurynas Biveinis 
Description:
There is an internals manual chapter on adding MySQL functions: https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-native-function.html

It does not explicitly list all the possible function return types and discusses the following three: double, long long, string. But MySQL also has (at least) JSON- and table-returning functions, i.e. JSON_ARRAY, JSON_TABLE.

Please extend the documentation to cover the how to write a JSON and table-returning functions too.

How to repeat:
See above
[14 Jun 2024 7:27] MySQL Verification Team 
Hello Laurynas,

Thank you for the document enhancement request.

regards,
Umesh
[14 Jun 2024 13:28] Laurynas Biveinis 
My attempt to document how to write a table-returning function: https://of-code.blogspot.com/2024/06/implementing-table-returning-mysql.html