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 154102 - Minor buglet in SQL CREATE with multi-column primary key
Summary: Minor buglet in SQL CREATE with multi-column primary key
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Shansi 11
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-11-28 15:27 UTC by freddiefishcake
Modified: 2009-02-19 20:37 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description freddiefishcake 2008-11-28 15:27:50 UTC
New SQL editor is a vast improvement on the older one, many thanks.

One small buglet - view data for a table, select a row and choose Show SQL for CREATE - if the table has a multi-column
primary key the resulting SQL has the comma in the wrong place -

CREATE TABLE TMAP_DOMAINS (REGION_ID NUMBER NOT NULL, DOMAIN_NUMBER NUMBER NOT NULL, GEOMETRY STRUCT, PRIMARY KEY
(DOMAIN_NUMBERREGION_ID, ));

should be:
CREATE TABLE TMAP_DOMAINS (REGION_ID NUMBER NOT NULL, DOMAIN_NUMBER NUMBER NOT NULL, GEOMETRY STRUCT, PRIMARY KEY
(DOMAIN_NUMBER, REGION_ID));
Comment 1 Shansi 11 2008-12-04 12:40:26 UTC
Needs Verification
Comment 2 Roman Mostyka 2008-12-04 16:30:45 UTC
freddiefishcake, can you verify that this issue was really fixed?