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 121018 - Need to quote reserved words when generating SQL
Summary: Need to quote reserved words when generating SQL
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Derby (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
: 127065 (view as bug list)
Depends on:
Blocks:
 
Reported: 2007-11-02 19:12 UTC by David Vancouvering
Modified: 2009-09-18 22:20 UTC (History)
1 user (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 2007-11-02 19:12:41 UTC 
The tools that generate SQL, like "View Data" and the visual query editor, need to quote reserved words, such as
"PUBLIC" for Java DB.  Otherwise attempts to execute SQL we generate that including identifiers that are reserved words
will fail.

The workaround is for the user to manually quote the identifiers that are reserved words.  I'm hoping this doesn't
happen too often, particularly now that we're no longer quoting when we create objects.
Comment 1 David Vancouvering 2008-03-29 01:33:17 UTC 
*** Issue 127065 has been marked as a duplicate of this issue. ***
Comment 2 Jiri Rechtacek 2009-02-10 15:33:06 UTC 
Reassigned to new owner.
Comment 3 Jiri Skrivanek 2009-09-15 12:40:04 UTC 
Fixed.
core-main #56745543a972
Comment 4 Quality Engineering 2009-09-18 22:20:36 UTC 
Integrated into 'main-golden', will be available in build *200909181401* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/56745543a972
User: Jiri Skrivanek <jskrivanek@netbeans.org>
Log: #121018 - Quote reserved words when generating SQL.