dbForge removes comments for the procedure parameters

[zhekaus]

dbForge removes comments for the procedure parameters when I edit anything inside Parameter panel.

Let’s say I have

...

Code: Select all

PROCEDURE host1355175_te.sp_fc_again(
IN p_user_id int /*comment for the procedure parameter is here*/, IN p_pair_id int, IN p_deb int, OUT o_res int)
  COMMENT 'Comment for the procedure is here'
BEGIN

...

“/*comment for the procedure parameter is here*/” will be removed if I, for instance, edit Comment via UI in Options panel or change parameter’s order.

[alexa]

This happens because the MySQL server doesn't store comments. So, it's not supported by MySQL itself.

[zhekaus]

MySQL server perfectly stores comments for stored procedures. It has such a problems for views only...
And my procedures had comments stored in mysql db before they've been touched by dbForge.

[alexa]

Sorry for the confusion. That's right. This is caused by dbForge.

We will try fixing this in one of the next product versions.

[alexa]

We are planning to handle this as a feature request. Please vote for https://devart.uservoice.com/forums/772 ... -procedure