--source include/default_optimizer_switch.inc

flush status;

show  status like "%custom_aggregate%";

delimiter |;

create aggregate function f1(x INT) returns int

begin

  declare tot_sum int default 0;

  declare continue handler for not found return tot_sum;

  loop

    fetch group next row;

    set tot_sum= tot_sum + x;

  end loop;

end|

delimiter ;|

create table t1 (sal int(10),id int(10));

INSERT INTO t1 (sal,id) VALUES (5000,1);

INSERT INTO t1 (sal,id) VALUES (2000,2);

INSERT INTO t1 (sal,id) VALUES (1000,3);

select f1(sal) from t1 where id>= 1;

show  status like "%custom_aggregate%";

create or replace view v1 as select f1(sal) from t1 where id>= 1;

select * from v1;

show  status like "%custom_aggregate%";

drop view v1;

drop table t1;

drop function f1;

select f1(sal) from t1 where id>= 1;

f1(sal)

8000

show  status like "%custom_aggregate%";

Variable_name	Value

Feature_custom_aggregate_functions	1

create or replace view v1 as select f1(sal) from t1 where id>= 1;

select * from v1;

f1(sal)

NULL

show  status like "%custom_aggregate%";

Variable_name	Value

Feature_custom_aggregate_functions	1

select f1(sal) from t1 where id>= 1;

f1(sal)

8000

show  status like "%custom_aggregate%";

Variable_name	Value

Feature_custom_aggregate_functions	1

create or replace view v1 as select f1(sal) from t1 where id>= 1;

select * from v1;

f1(sal)

8000

show  status like "%custom_aggregate%";

Variable_name	Value

Feature_custom_aggregate_functions	2