You create a table and a stored procedure:
CREATE TABLE t1 (f1 int);
INSERT INTO t1 VALUES (1), (2) , (3), (4), (5);
CREATE PROCEDURE sum_t1()
BEGIN -
DECLARE done INT DEFAULT 0;
DECLARE va1 INT;
DECLARE result CURSOR FOR SELECT f1 FROM t1;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1;
OPEN cur;
REPEAT -
FETCH cur INTO va1;
IF NOT done THEN -
SET result = result +va1;
END IF:
UNTIL done END REPEAT;
SELECT result;
END -
CALL sum_t1();
What is the result of the CALL statement?