MySQL Forums
Forum List  »  Stored Procedures

Re: Mysql 8.0 crash while calling stored proc
Posted by: Bakhtiyor Bahritidinov
Date: March 17, 2021 11:43PM

Creating a table is not giving any error.

Even a simple procedure/function like given below crashes MySQL when calling it:

CREATE DEFINER=`root`@`localhost` FUNCTION `test`(param1 int) RETURNS int
DETERMINISTIC
BEGIN
DECLARE var1 INTEGER;
set var1 = param1 + 100;
RETURN var1;
END

Note: But if this function is created without any arguments it is possible to call it and it returns the result.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql 8.0 crash while calling stored proc
107
March 17, 2021 11:43PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.