Hi,

I am not sure of the point of that mdev.  First, arrays are not table functions.  Arrays are data structures.  A table function can certainly return all the items in an array data structure as rows (which would be part of #820)  but that doesn't mean that a table function could replace an ARRAY data type.  Arrays also have to be able to be passed to stored routines and stored in tables too, or they are virtually useless.  

Second, WL#820, which far precedes that mdev, adds real table functions without magic "pretend" storage engine as suggested in the later mdev.  In any case, you can't return an array or table, from a UDF, without changing the UDF interface which will break other UDF.  The UDF interface IS NOT VERSIONED.  

wl#820 adds external stored procedures and doesn't modify the udf interface (UDF can rot)  The mysql bug link I sent makes item functions internally pluggable, so they could support table functions as well and provide a replacement for UDF.  Add an ARRAY data type and implement these patches (which are from Antony Curtis) and you'll get what you want.

It would be a real shame to replace wl#820 work with some half-backed UDF that has not access to internals.

--Justin

On Tue, Mar 10, 2015 at 12:04 PM, Federico Razzoli <federico_raz@yahoo.it> wrote:
This JIRA task doesn't mention GSoC, but it seems to be what you are asking for:

https://mariadb.atlassian.net/browse/MDEV-5199

Hope it helps.

Federico


--------------------------------------------
Mar 10/3/15, Delveri chick <chickdelveri@gmail.com> ha scritto:

 Oggetto: [Maria-discuss] GSOC 2015 :UDFs returning arrays
 A: maria-discuss@lists.launchpad.net
 Data: Martedì 10 marzo 2015, 19:28

 Hi My name is Blessing
 Atie and i would love to participate in the Google summer of
 code 2015 under Mariadb. I am interested in the project UDF
 returning arrays. I have build mariadb from source and and i
 also  ran  the test suites. I am currently studing the
 sql/sql.** files to understand UDF's and  i also
 downloaded some ebook on mysql internals and mysql plugin
 development  which im reading while hoping to find a
 breakthrough on this project in them. I would love to know
 if there are any bugs related to this task on JIRA I could
 work on as a means of preparing for the project.Please give me the
 link.
 Regards
 -----Segue allegato-----

 _______________________________________________
 Mailing list: https://launchpad.net/~maria-discuss
 Post to     : maria-discuss@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~maria-discuss
 More help   : https://help.launchpad.net/ListHelp


_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp