Bug Report: SQL Commenting that screw up queries

Bug Report: SQL Commenting that screw up queries

  
Hi All,

Just as a word or warning for people creating advanced queries and that use COMMENTS in those queries.
There is a bug in the SQL processor that makes the double hyphens used for commenting disable every statement AFTER the hyphens.


Make sure not to use the two hyphens to place a comment.
Outsystems will "ignore" the linefeeds behind it and concatenate everything into one row.
Solution
This is absolutely true, and very valuable advise, but this has been the case since always (well, at least 4.2 which was the first version I worked with). The cause is that the Platform will put everything on a long line, before sending it to the database (at least that what I recall some OutSystems engineer writing here a while ago). You really mean you recently encountered this for the first time?
Solution
I too encountered same problem one year before hence avoiding comments in Advance Queries.