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

Summary: Need to quote reserved words when generating SQL
Product: db Reporter: David Vancouvering <davidvc>
Component: DerbyAssignee: Jiri Rechtacek <jrechtacek>
Status: RESOLVED FIXED    
Severity: blocker CC: thompsonwd40
Priority: P3    
Version: 6.x   
Hardware: All   
OS: All   
Issue Type: DEFECT Exception Reporter:

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.