Procedure bug.

[expired user #6709]'s profile image [expired user #6709] posted 11 years ago in General Permalink
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.
ansgar's profile image ansgar posted 11 years ago Permalink
Yes, issue was already posted in the tracker, see issue #3051.
ansgar's profile image ansgar posted 11 years ago Permalink
Routine editor should be fixed in r4266.

Can you verify if export is also fixed? Could not reproduce that here anyway.
[expired user #6709]'s profile image [expired user #6709] posted 11 years ago Permalink
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:
ansgar's profile image ansgar posted 11 years ago Permalink
Please post such follow ups in the tracker, see above link.

However, that's also fixed now.
[expired user #6709]'s profile image [expired user #6709] posted 11 years ago Permalink
Ok. See new issue #3053. :)

Please login to leave a reply, or register at first.