Procedure bug.
| User, date | Message |
|---|---|
|
Written by gouranga
6 months ago Category: General 3 posts since Wed, 05 Dec 12 |
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. |
|
Written by ansgar
6 months ago 4029 posts since Fri, 07 Apr 06 |
Yes, issue was already posted in the tracker, see issue #3051. |
|
Written by ansgar
6 months ago 4029 posts since Fri, 07 Apr 06 |
Routine editor should be fixed in r4266. Can you verify if export is also fixed? Could not reproduce that here anyway. |
|
Written by gouranga
6 months ago 3 posts since Wed, 05 Dec 12 |
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: 
|
|
Written by ansgar
6 months ago 4029 posts since Fri, 07 Apr 06 |
Please post such follow ups in the tracker, see above link. However, that's also fixed now. |
|
Written by gouranga
6 months ago 3 posts since Wed, 05 Dec 12 |
Ok. See new issue #3053. :) |
|
Please login to leave a reply, or register at first. |