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 138517 - SQL CC: identifier quoting inconsistent
Summary: SQL CC: identifier quoting inconsistent
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: Macintosh All
: P2 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
: 139558 (view as bug list)
Depends on:
Blocks:
 
Reported: 2008-06-27 18:32 UTC by David Vancouvering
Modified: 2008-07-21 10:27 UTC (History)
2 users (show)

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 David Vancouvering 2008-06-27 18:32:59 UTC 
If I do SELECT EMPLOYEE. and CTRL-SPACE, I get a list of columns, I select one, and it looks good.

If I do SELECT EMPLOYEE.L and CTRL-SPACE, I get SELECT EMPLOYEE."LASTNAME".  

We should be consistent.

Also, a previous pass at quoting identifiers I put a lot of effort into quoting only when necessary, rather than
conservatively always by default.

As part of this, I wrote a helper class for quoting identifiers that determines if an identifier needs to be quoted or not.

See org.netbeans.db.api.sql.support.SQLIdentifiers
Comment 1 Andrei Badea 2008-07-16 16:17:54 UTC 
*** Issue 139558 has been marked as a duplicate of this issue. ***
Comment 2 Andrei Badea 2008-07-18 15:04:43 UTC 
81dc50b214cb
Comment 3 Roman Mostyka 2008-07-21 10:27:09 UTC 
Verified with build 080720.