← Back to team overview

maria-developers team mailing list archive

Re: Aggregate stored functions [MDEV-7773]

 

Hi Sergei,
Thanks that answers my question,  I will soon get back with questions .

On Sun, Mar 6, 2016 at 2:52 PM, Sergei Golubchik <serg@xxxxxxxxxxx> wrote:

> Hi, Varun!
>
> On Mar 06, Varun Gupta wrote:
> > Hi Sergei,
> > I understand that having a cursor like syntax we would have  to write
> some
> > new code . What I would have liked to know is that the more details
> should
> > be discussed which need to be incorporated in the implementation of the
> > aggregate functions.  Basically what I am asking is what all details have
> > to be there in the implementation of the aggregate functions.
>
> I don't think I understand your question.
> But anyway to implement aggregate stored functions one would need
> 1. fix the parser to support the new syntax
> 2. fix the saving/loading code to store additional attributes (like,
>    store the fact that the function is aggregate)
> 3. fix stored function execution code to be able to pause and resume the
>    execution
> 4. create an Item_sum_sp to be able to use aggregate stored functions in
>    queries.
>
> optional:
>
> 5. add support for window functions
>
> Regards,
> Sergei
> Chief Architect MariaDB
> and security@xxxxxxxxxxx
>

Follow ups

References