DB2 inline comments

Feature requests and their debate

DB2 inline comments

Postby marty » Mon Aug 29, 2011 3:13 pm

It's not possible to use inline comments with DB2, a limitation I myself find quite strange. Queries with additional information like
SELECT Names --Usernames
FROM Users

are not possible because of the comment after the select.
Can the parser be configured to ignore '--'-style comments as well as /* ...*/?
marty
 
Posts: 19
Joined: Mon Aug 29, 2011 3:07 pm

Re: DB2 inline comments

Postby Support » Mon Aug 29, 2011 5:31 pm

That's pretty strange.
Inline (or multiline) comments are completely acceptable inside of SQL queries in any SQL dialect. It was tested for different databases (at least Oracle, DB2 and MS SQL).
So it looks like a bug. Probably it is related to the difference of EOL character in UNIX/Windows systems.

Could you say what OS version do you use? And what DBeaver version.
Thanks!
Support
 
Posts: 49
Joined: Thu Mar 17, 2011 10:11 am

Re: DB2 inline comments

Postby marty » Tue Aug 30, 2011 8:17 am

marty
 
Posts: 19
Joined: Mon Aug 29, 2011 3:07 pm


Return to Feature Requests



Who is online

Users browsing this forum: No registered users and 2 guests