SQL editor, syntax highlight bug if '' was used

Note: please leave bug reports and feature requests on

SQL editor, syntax highlight bug if '' was used

Postby maqiushi » Thu Jul 16, 2015 12:46 am

As described in the attached file.
If we use some kind of too much quotation marks in the SQL query. The SQL syntax highlight not work after ''
If we add a single quotation mark in a comment, it behaves correct.

Looks like a bug here. :)

Is there anyway we can correct this by some preference settings?

Thanks,
Qiushi
Attachments
2.png
add a single quotation mark in the comments correct the behavior
2.png (22.43 KiB) Viewed 11087 times
1.png
SYNTAX HIGHLIGHT ERROR
1.png (12.08 KiB) Viewed 11087 times
maqiushi
 
Posts: 1
Joined: Thu Jul 16, 2015 12:34 am

Re: SQL editor, syntax highlight bug if '' was used

Postby lopard » Mon Jan 11, 2016 12:03 pm

Another highlight bug

after this line l_str := REPLACE(l_str,'\','\\') ; the lighlight not work properly. I think the problem is the double /
lopard
 
Posts: 1
Joined: Mon Jan 11, 2016 12:00 pm

Re: SQL editor, syntax highlight bug if '' was used

Postby Serge » Tue Jan 12, 2016 12:40 pm

Actually problem is in the slash followed by ' symbol. In string literals single slash has to be escaped as \\.
It is SQL dialect dependent issue. Some dialects do not require to escape \.
What database/driver do you use?
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Support



Who is online

Users browsing this forum: No registered users and 11 guests