Removal Of Comments from .sql files
Posted: Tue 10 Feb 2015 20:26
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.
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.