v10 Bug: Syntax highlighting with q'[ ]' syntax

[Colin Nicholls]

I have found that PL/SQL Developer v10.02 has a bug in the syntax highlighting logic, when the source includes the quoted string (q'[..]') syntax.

Internal single-quotes no longer seem to be recognized correctly, and the "string" text color continues beyond the final quoted string delimter.

Updated note: I realize now that the curly braces are necessary to cause the highlighting error. This is probably why this problem hasn't been detected earlier.

However, this was working correctly in 8.04 (sorry, I do not have 9 to check.):

 

[null0000]

9.0.6.1665

 

[Marco Kalter]

This is indeed a known syntax highlighting issue. A }' will visually close a q'[

Version 8.0 did not support Q quotes at all, it visually closes the string at the next quote.

 

[Colin Nicholls]

OK, thanks Marco. I understand it is not a critical issue

 

[Luis]

Hi,

Colin, I have to disagree with you! This is a critical issue; when maintaining complex code, syntax highlighting is extremely important in my opinion. That is one of the reasons here we use PL/SQL developer instead of, say notepad.

I have just upgraded to version 10.0.3.1701 and I am having the same issue (it was OK in the previous version, 8.x)

I see that there is a new patch 10.0.3.1704, has this issue been fixed there? (I need to ask because I cannot update it myself, I need to follow a bureaucratic procedure and ask the support desk so I just wanted to check beforehand)

Thanks
Luis

 

[Luis]

Not to mention that the statement pair highlighting (e.g. IF/END IF, LOOP/END LOOP) does not work any more after syntax highlighting is broken!

This IS a critical functionality, specially when you are maintaining code with multiple nested LOOPs and IFs.

Please let us know whether it is fixed in 1704 or, if not, when it will be fixed!