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 75765 - SQL editor does not recognise 'Replace' as keyword
Summary: SQL editor does not recognise 'Replace' as keyword
Status: RESOLVED DUPLICATE of bug 76449
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 5.x
Hardware: All All
: P3 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
: 76406 (view as bug list)
Depends on:
Blocks: 152817
  Show dependency tree
 
Reported: 2006-05-02 09:43 UTC by Max Sauer
Modified: 2012-07-10 17:37 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
screenshot (23.68 KB, image/png)
2006-05-02 09:45 UTC, Max Sauer 		Details
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 Max Sauer 2006-05-02 09:43:42 UTC 
'replace' is not recognised as PL/SQL keyword and is not ephasized by SQL
editor. See attached screenshot.

-----
NB 5.5 beta b 200505020200
JDK 1.6.0 b81
Solaris 10 /Sparc
Comment 1 Max Sauer 2006-05-02 09:45:51 UTC 
Created attachment 30154 [details]
screenshot
Comment 2 Andrei Badea 2006-05-03 12:40:42 UTC 
The SQL editor is DBMS-independent, so it only recognizes the keywords specified
in the SQL-99 spec. I have a book about SQL-99 which specifies some identifiers
which are used as keywords by database servers and should not be used as
identifiers (REPLACE is among them). The SQL editor could maybe recognize them
as keywords. But I'm not sure about it and it's not a defect, but an enhancement.
Comment 3 Max Sauer 2006-05-11 16:54:27 UTC 
When working on this, please make 'if' a keyword also. I looks wierd when 'else'
is emphasized as a keyword and 'if' does not :)
Comment 4 Andrei Badea 2006-05-12 08:51:39 UTC 
Yes, this is a bug. IF is a SQL reserver keyword, but is not the SQL editor's
list of keywords. Since this issue is an enhancement and will not be fixed for
5.5, could you please file a new issue (defect) for IF?
Comment 5 Max Sauer 2006-05-12 09:09:18 UTC 
I have filed issue 76253, concerning the IF keyword.
Comment 6 Andrei Badea 2006-05-16 10:49:24 UTC 
*** Issue 76406 has been marked as a duplicate of this issue. ***
Comment 7 Jiri Rechtacek 2009-10-16 14:12:28 UTC 
Reassigned to new owner.
Comment 8 matthias42 2012-07-10 17:37:56 UTC 

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