From febbe0822c855904e78572b2954a10db55d5d362 Mon Sep 17 00:00:00 2001 From: varunraiko Date: Sat, 13 Aug 2016 01:30:18 +0530 Subject: error added to the agg_parsing test ER_NOT_AGGREGATE_FUNCTION --- mysql-test/r/agg_parsing.result | 2 +- mysql-test/t/agg_functions_sum.test | 15 --------------- 2 files changed, 1 insertion(+), 16 deletions(-) delete mode 100644 mysql-test/t/agg_functions_sum.test (limited to 'mysql-test') diff --git a/mysql-test/r/agg_parsing.result b/mysql-test/r/agg_parsing.result index 5e4298b7b5b..31ba6dcc9a2 100644 --- a/mysql-test/r/agg_parsing.result +++ b/mysql-test/r/agg_parsing.result @@ -4,7 +4,7 @@ set x=5; fetch group next row; return x+1; end | -ERROR HY000: FETCH GROUP NEXT ROW instruction is only allowed in aggregate functions +ERROR HY000: Non-aggregate function contains aggregate specific instructions: (FETCH GROUP NEXT ROW) create aggregate function agg_increm() returns INT begin declare z int default 0; diff --git a/mysql-test/t/agg_functions_sum.test b/mysql-test/t/agg_functions_sum.test deleted file mode 100644 index da0f959a058..00000000000 --- a/mysql-test/t/agg_functions_sum.test +++ /dev/null @@ -1,15 +0,0 @@ -DELIMITER $$; -CREATE AGGREGATE FUNCTION total_sum(x DOUBLE) RETURNS DOUBLE -BEGIN - DECLARE sum DOUBLE DEFAULT 0; - DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' RETURN sum; - LOOP - FETCH GROUP NEXT ROW; - SET sum=sum+x; - END LOOP; -END -$$ -DELIMITER ;$$ - -show create function total_sum; -DROP function total_sum; -- cgit v1.2.1