[Solved] Prevent two hyphens in a string from being treated as a comment

4 Posts
2 Users
0 Reactions
1,898 Views
Posts: 17
Topic starter
(@benjamin-moeller)
Member
Joined: 4 years ago
[#86]

Hello
I have the following SQL

SELECT
CASE
WHEN bs = 'B
THEN '12Xkljsdg--X'
ELSE receiverid
END AS buyerparty
from base.

However, if I have selected the setting that "Convert Line comments into Block Comments", it destroys the SQL for me.
The result is then:

SELECT
CASE
WHEN bs = 'B
THEN '12Xkljsdg/*--X'*/
ELSE receiverid
END AS buyerparty
from base

which is wrong.

How can I prevent this?

Greetings
Ben


3 Replies
Guido
Posts: 295
Admin
(@admin)
Member
Joined: 5 years ago

Hi @benjamin-moeller,

thanks for your feedback.

This is a parser error.

Will fix this asap

Regards

Guido

 

 


Reply
Guido
Posts: 295
Admin
(@admin)
Member
Joined: 5 years ago

Hi @benjamin-moeller,

please give the new Release 6.23.9 a try. This issue should be fixed

Regards

Guido


Reply
1 Reply
(@benjamin-moeller)
Joined: 4 years ago

Member
Posts: 17

@admin Great!
This fast support alone is worth every cent of the licence!


Reply
Share: