Re: [Maria-developers] Aggregate stored functions [MDEV-7773]
Hi, Varun! On Mar 21, Varun Gupta wrote:
Hi Sergei,
4) :create an Item_sum_sp to be able to use aggregate stored functions in queries. Does this mean we can have the aggregate stored functions in the SELECT , WHERE etc clauses?can you give me more details about this.
Yes, of course. That's how functions are used, right? :) SELECT AVG(x), COUNT(y), MAX(z) FROM t1 WHERE aaa=12 GROUP BY bbb; for example. Regards, Sergei Chief Architect MariaDB and security@mariadb.org
Hi Sergei , I have created a draft proposal and submitted to summerofcode website. I haven't written the project timeline yet. Please I would appreciate if you could go through it and leave comments so that I can make any necessary corrections. On Mon, Mar 21, 2016 at 2:34 PM, Sergei Golubchik <serg@mariadb.org> wrote:
Hi, Varun!
On Mar 21, Varun Gupta wrote:
Hi Sergei,
4) :create an Item_sum_sp to be able to use aggregate stored functions in queries. Does this mean we can have the aggregate stored functions in the SELECT , WHERE etc clauses?can you give me more details about this.
Yes, of course. That's how functions are used, right? :)
SELECT AVG(x), COUNT(y), MAX(z) FROM t1 WHERE aaa=12 GROUP BY bbb;
for example.
Regards, Sergei Chief Architect MariaDB and security@mariadb.org
Hi, Varun! On Mar 22, Varun Gupta wrote:
Hi Sergei , I have created a draft proposal and submitted to summerofcode website. I haven't written the project timeline yet. Please I would appreciate if you could go through it and leave comments so that I can make any necessary corrections.
I've looked it through, but I cannot comment, because your document is read-only. Open it for comments, please, then I'll leave some :) Regards, Sergei Chief Architect MariaDB and security@mariadb.org
Hi Sergei, Sorry for the inconvenience , now you can comment on the document :) On Tue, Mar 22, 2016 at 1:25 PM, Sergei Golubchik <serg@mariadb.org> wrote:
Hi, Varun!
On Mar 22, Varun Gupta wrote:
Hi Sergei , I have created a draft proposal and submitted to summerofcode website. I haven't written the project timeline yet. Please I would appreciate if you could go through it and leave comments so that I can make any necessary corrections.
I've looked it through, but I cannot comment, because your document is read-only. Open it for comments, please, then I'll leave some :)
Regards, Sergei Chief Architect MariaDB and security@mariadb.org
participants (2)
-
Sergei Golubchik
-
Varun Gupta