I get an error on line 12 (in the endif statement). I believe that I am doing something wrong in IF or ELSE, can someone help me?
DELIMITER $$ CREATE FUNCTION TEST (`param` INT) RETURNS INT DETERMINISTIC BEGIN DECLARE `var` INT; SET `var` = 1; IF `param` > 0 THEN SET `var` = `var` + `param`; END IF; RETURN `var`; END$$
EDIT: (same function with case, not the same problem)
DELIMITER $$ CREATE FUNCTION TEST (`param` INT) RETURNS INT DETERMINISTIC BEGIN DECLARE `var` INT; SET `var` = 1; SET `var` = CASE WHEN `param` > 0 THEN `var` + `param` ELSE `var` END ; RETURN `var`; END$$
source share