Removal Of Comments from .sql files

[mysqluser007]

Comments are being removed from my SQL code. This seems to be caused by adding the comment in the 'Text' tab, then making a change in the 'Query Builder' tab.

For instance, If I have the following code:

SELECT
Users.id,
Users.user_name,
User_Role.Role_id
FROM Users
LEFT OUTER JOIN User_Role
ON Users.id = User_Role.User_id

Lets say I add /* Comment */ in the 'Text' tab, resulting in

SELECT
/*comment*/
Users.id,
Users.user_name,
User_Role.Role_id
FROM Users
LEFT OUTER JOIN User_Role
ON Users.id = User_Role.User_id

The code executes fine, saves fine, and the comment is there if I close and re-open the .sql file without making any changes in the 'Query Builder' tab.

But-if I go into the 'Query Builder' tab, and for instance change the left join to a inner join, the comment disappears when I switch back to the 'Text' tab.

[alexa]

We were able to reproduce this issue and will fix it in one of the next product builds. We will notify you once it's available for downloading.

[mysqluser007]

Has this issue been fixed in standard edition 3.3.30? Seems to still occur.

[alexa]

This issue is still to be fixed.

[jmustac]

Is this issue fixed? It still seems to be a problem in v 5.7.31 for SQL Server. Any view on the timing of fixing this or a workaround - its a real pain.

[alexa]

This forum topic was related to dbForge Studio for MySQL.

In case you are referring to another our product dbForge Studio for SQL Server, please create a new topic at dbForge for SQL Server forum viewforum.php?f=33

Alternatively, you can contact support at supportATdevartDOTcom.

[Chris79tr]

I also had this problem,uno online and the error is still not fixed tunnel rush

[dzhanhira]

Kindly be informed that it's not fixed yet, but we have successfully reproduced it and we are going to fix it in one of the next versions.