--source include/have_udf.inc

--replace_result $UDF_EXAMPLE_LIB UDF_EXAMPLE_LIB
eval CREATE AGGREGATE FUNCTION avgcost
        RETURNS REAL SONAME "$UDF_EXAMPLE_LIB";
		
CREATE TABLE `foo` (
  `quantity` int(11) default NULL,
  `price` double default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

insert into foo values(10,40), (5,30), (7,50);

select avgcost(quantity, price) - avgcost(quantity, price) from foo;
select avgcost(quantity, price) - avgcost(quantity, price) from foo;
select avgcost(quantity, price) - avgcost(quantity, price) from foo;
select avgcost(quantity, price) - avgcost(quantity, price) from foo;
select avgcost(quantity, price) - avgcost(quantity, price) from foo;
select avgcost(quantity, price) - avgcost(quantity, price) from foo;
select avgcost(quantity, price) - avgcost(quantity, price) from foo;
select avgcost(quantity, price) - avgcost(quantity, price) from foo;
select avgcost(quantity, price) - avgcost(quantity, price) from foo;
select avgcost(quantity, price) - avgcost(quantity, price) from foo;