Re: [Maria-discuss] Source package for Ubuntu Precise is missing

2015-03-10 Thread Daniel Bartholomew
On Mon, Mar 9, 2015 at 10:48 PM, Kouhei Sutou wrote: > It seems that source package of MariaDB 10.0.17 for Ubuntu > Precise Pangolin (12.04 LTS) isn't provided. > Binary packages for Precise Pangolin are provided. > > mariadb-10.0_10.0.17+maria-1~trusty.dsc (for Trusty Tahr) and > mariadb-10.0_10.

Re: [Maria-discuss] GSOC 2015 :UDFs returning arrays

2015-03-10 Thread Justin Swanhart
Hi, Sorry for the misunderstanding. On Tue, Mar 10, 2015 at 3:17 PM, Oleksandr Byelkin wrote: > Hi! > > On 10.03.15 21:41, Justin Swanhart wrote: > >> No, >> >> You SAY the UDF can support them, but you neglect to point to a technical >> way how. >> >> If you want to return a row as an array, w

Re: [Maria-discuss] GSOC 2015 :UDFs returning arrays

2015-03-10 Thread Oleksandr Byelkin
Hi! On 10.03.15 21:41, Justin Swanhart wrote: No, You SAY the UDF can support them, but you neglect to point to a technical way how. If you want to return a row as an array, well, how do you add an item to a row outside of the UDF, remove one? How do you count the items in the row? How d

Re: [Maria-discuss] Enabling feedback pluging for MariaDB 10.1.4

2015-03-10 Thread Sergei Golubchik
Hi, Federico! On Mar 10, Federico Razzoli wrote: > I am no lawyer, but please consider possible legal problems for users. > 1) I sign an NDA with my customer > 2) I enable Feedback > 3) You see things I shouldn't reveal. > I know that my data are not sent. And you say it's anonymous. > But you wil

Re: [Maria-discuss] Enabling feedback pluging for MariaDB 10.1.4

2015-03-10 Thread Sergei Golubchik
Hi, Justin! On Mar 10, Justin Swanhart wrote: > > Where is it described exactly what is collected? Descriptions I see > say it is "basically ..." well, no, I want a full description of all > data collected, particularly if it collects versions of software as > knowing what version of software I

Re: [Maria-discuss] R: GSOC 2015 :UDFs returning arrays

2015-03-10 Thread Justin Swanhart
wl#820 also has table functions in it: http://antbits.blogspot.com/2009/01/table-functions-in-mysql.html mysql> INSTALL PLUGIN Deep_Thought SONAME 'psm_example.so'; Query OK, 0 rows affected (0.10 sec) mysql> CREATE FUNCTION test.FooAnswer() -> RETURNS TABLE(answer TEXT) -> NO SQL LANGUAG

Re: [Maria-discuss] R: GSOC 2015 :UDFs returning arrays

2015-03-10 Thread Sergei Golubchik
Hi, Justin! On Mar 10, Justin Swanhart wrote: > > 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 doe

Re: [Maria-discuss] GSOC 2015 :UDFs returning arrays

2015-03-10 Thread Justin Swanhart
No, You SAY the UDF can support them, but you neglect to point to a technical way how. If you want to return a row as an array, well, how do you add an item to a row outside of the UDF, remove one? How do you count the items in the row? How do you get an item by index? If you want to use inter

Re: [Maria-discuss] GSOC 2015 :UDFs returning arrays

2015-03-10 Thread Oleksandr Byelkin
Hi! On 10.03.15 21:01, Justin Swanhart wrote: [accidentally replied only to sender, pasting reply here to all] Hi, So how exactly would you go about returning a row type? You get four choices with UDF: STRING_RESULT INT_RESULT REAL_RESULT DECIMAL_RESULT (which is handled just like strings,

Re: [Maria-discuss] GSOC 2015 :UDFs returning arrays

2015-03-10 Thread Justin Swanhart
[accidentally replied only to sender, pasting reply here to all] Hi, So how exactly would you go about returning a row type? You get four choices with UDF: STRING_RESULT INT_RESULT REAL_RESULT DECIMAL_RESULT (which is handled just like strings, because decimal was a string when UDF interface was

Re: [Maria-discuss] GSOC 2015 :UDFs returning arrays

2015-03-10 Thread Oleksandr Byelkin
Hi! On 10.03.15 19:38, Justin Swanhart wrote: Hi, MySQL has no ARRAY data type. In array is basicaly a nested table data type and MySQL doesn't support nested tables either, except through dynamic columns. So, a UDF that returned an array could only be used by other UDF that understand arr

Re: [Maria-discuss] R: GSOC 2015 :UDFs returning arrays

2015-03-10 Thread Justin Swanhart
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 ARRA

[Maria-discuss] R: GSOC 2015 :UDFs returning arrays

2015-03-10 Thread Federico Razzoli
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 ha scritto: Oggetto: [Maria-discuss] GSOC 2015 :UDFs returning arra

Re: [Maria-discuss] GSOC 2015 :UDFs returning arrays

2015-03-10 Thread Justin Swanhart
Hi, MySQL has no ARRAY data type. In array is basicaly a nested table data type and MySQL doesn't support nested tables either, except through dynamic columns. So, a UDF that returned an array could only be used by other UDF that understand arrays. That isn't very useful. I see two options if

[Maria-discuss] GSOC 2015 :UDFs returning arrays

2015-03-10 Thread Delveri chick
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 an

[Maria-discuss] R: Stored Procedure debugger from Peter Gulutzan and Trudy Pelzer

2015-03-10 Thread Federico Razzoli
I don't want to show critisism against projects like this - I hope that this is clear. There are many debuggers, and they are more than welcome. Even Oracle has a debugger, if you use Windows and Visual Studio (sigh). But I still think that MariaDB needs a native debug API, which fully supports

Re: [Maria-discuss] Enabling feedback pluging for MariaDB 10.1.4

2015-03-10 Thread Sergei Golubchik
Hi, Justin! On Mar 09, Justin Swanhart wrote: > > I agree with Kristian. Given the way it works, the statistics are > really meaningless and I feel you shouldn't drive important choices > based on bad statistics. Of course. This statistics is not *the only* argument. For important decisions the

[Maria-discuss] Stored Procedure debugger from Peter Gulutzan and Trudy Pelzer

2015-03-10 Thread Alexander Barkov
Hi, Peter Gulutzan and Trudy Pelzer announced their GUI debugger for stored procedures. Sources, binaries and a demo are available here: http://ocelot.ca/blog/blog/2015/03/02/the-ocelotgui-debugger/ This is a great news. Greetings. ___ Mailing li

Re: [Maria-discuss] Enabling feedback pluging for MariaDB 10.1.4

2015-03-10 Thread Sergei Golubchik
Hi, Adam! On Mar 09, Adam Scott wrote: > Maybe make it an option when installing? Yes, that'd be great. On Windows there's a GUI installer, and it has a checkbox for feedback plugin. That's why we get >95% of reports from Windows. Most users don't mind having it enabled, so it seems. So if rpm/

Re: [Maria-discuss] Enabling feedback pluging for MariaDB 10.1.4

2015-03-10 Thread Sergei Golubchik
Hi, Kristian! On Mar 09, Kristian Nielsen wrote: > > > As most MariaDB users should know, the feedback is totally anonymous > > and no private or sensitive information is being sent. > > > > Any comments, suggestions or recommendations? > > I think it is a bad idea. Please do not do it. > > "Ph