There's a bug with procedures in latest versions of Heidi (at least 4.0.0.4263 and two previous).
Heidi is missing keyword «PROCEDURE» in the create statement.
Because of that you can't export correctly, add/remove/rename parameters, change definer.
Regards,
Sergey.
Procedure bug.
Yes, issue was already posted in the tracker, see issue #3051.
I can verify that the bug is still present in another form.
Heidi shows CREATE FUNCTION instead of CREATE PROCEDURE, and because a function must return a value any sql-action with a normal procedure causes sql-error 1064.
This is Heidi export code:
This is how it should be:
Heidi shows CREATE FUNCTION instead of CREATE PROCEDURE, and because a function must return a value any sql-action with a normal procedure causes sql-error 1064.
This is Heidi export code:
This is how it should be:
Ok. See new issue #3053. :)
Please login to leave a reply, or register at first.