What's wrong with this MySQL CREATE FUNCTION?

Question

What's wrong with this MySQL CREATE FUNCTION?

Navigation

#1 by (0 votes)

1

What is wrong with this create function? I can not figure it out. Already the error in the first line.

CREATE FUNCTION SEQ_NEXT_VAL() 
RETURNS INT 
DETERMINISTIC
BEGIN
  DECLARE retorno INT;

  SELECT MAX(IDE_ERROR) INTO retorno FROM ERROR_LOGGING;
  IF retorno = NULL THEN
    retorno = 1;
  ELSE
    retorno = retorno + 1;
  END IF;

  RETURN retorno;
END;

mysql

asked by anonymous 01.12.2017 / 16:56

1 answer

Image in src goes to background-image and does not resize maxLine already set but jump line

score 0 · Answer 1

Missing set of variables:

DROP FUNCTION IF EXISTS SEQ_NEXT_VAL;
DELIMITER |
CREATE FUNCTION SEQ_NEXT_VAL() 
RETURNS INT 
DETERMINISTIC
BEGIN
  DECLARE retorno INT;

  SELECT MAX(IDE_ERROR) INTO retorno FROM ERROR_LOGGING;
  IF retorno = NULL THEN
    SET retorno = 1;
  ELSE
    SET retorno = retorno + 1;
  END IF;

  RETURN retorno;
END
|
DELIMITER ;