This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 241482 - ESCAPE '\' breaks SQL code highlighting
Summary: ESCAPE '\' breaks SQL code highlighting
Status: RESOLVED DUPLICATE of bug 200479
Alias: None
Product: db
Classification: Unclassified
Component: PL SQL (show other bugs)
Version: 7.4
Hardware: PC Windows 7
: P3 normal with 1 vote (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-02-06 11:55 UTC by fedind
Modified: 2014-02-08 07:57 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description fedind 2014-02-06 11:55:11 UTC 
Product Version = NetBeans IDE 7.4 (Build 201310111528)
Operating System = Windows 7 version 6.1 running on amd64
Java; VM; Vendor = 1.7.0_51
Runtime = Java HotSpot(TM) 64-Bit Server VM 24.51-b03

In PL/SQL we can escpae special characters in LIKE statement with ESCAPE keyword

IF test LIKE '%\_sample\_%' ESCAPE '\'

But it breaks sql code syntax highlighting.
Comment 1 matthias42 2014-02-08 07:57:23 UTC 
The SQL lexer treats the \ character as a valid escape. This in turn breaks syntax highlighting, as the final quoting sign is not recognised as a closing quote.

This is a duplicate of bug 200479.

*** This bug has been marked as a duplicate of bug 200479 ***