create aggregate function f1(x INT) returns double

begin

declare z double default 0;

declare continue handler for not found return z;

loop

fetch group next row;

set z = z + x;

end loop;

end|

show function code f1;

Pos	Instruction

0	set z@1 0

1	hpush_jump 3 2 CONTINUE

2	freturn double z@1

3	

4	set z@1 z@1 + x@0

5	jump 3

6	hpop 1