Comments in named queries?

Have read several posts here that seem to clearly state that comments (in the SQL) cause problems, errors, index out of range etc.

I’m assuming this is still the case?

And that the (Settings) tab’s (Description) field is the next best and safest place to add, what would be, comments to your SQL?

Comments are fine, it’s just that our parser is (currently) too dumb to distinguish a commented parameter from a legitimate one, so:

SELECT * FROM TABLE WHERE 
A = :param
--AND B = :param2

Should be fine, but is what currently throws an error, because the parser thinks it needs an additional value for param2.

1 Like

Well, the JDBC spec does not explicitly say comments are allowed, just that at least single statements are accepted. Some drivers accept more, or even SQL scripts.

1 Like