← Back to team overview

maria-developers team mailing list archive

Re: Aggregate stored functions [MDEV-7773]

 

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@xxxxxxxxxxx> 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@xxxxxxxxxxx
>

Follow ups

References