maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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