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 31952 - Cannot create table with compound primary key
Summary: Cannot create table with compound primary key
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: -S1S-
Hardware: PC Linux
: P3 blocker (vote)
Assignee: Radko Najman
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-03-12 15:43 UTC by Martin Schovanek
Modified: 2005-11-18 15:35 UTC (History)
0 users

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 Martin Schovanek 2003-03-12 15:43:59 UTC 
[DB2, Oracle]
Create table with compound primary key generates
wrong code:
---------------
create table "DB2INST1"."AAA"
(
        "x1" SMALLINT not null,
        "x2" SMALLINT not null,
        primary key (x1, x2)
)
---------------
better (acceptable by DB2, Ora, MsSQL) is:
---------------
create table "DB2INST1"."AAA"
(
        "x1" SMALLINT not null,
        "x2" SMALLINT not null,
        primary key ("x1", "x2")
)
---------------
Comment 1 Radko Najman 2003-09-09 15:01:02 UTC 
Database Explorer is not designed to create compound indexes/keys.
Changing to enhancement.
Comment 2 Radko Najman 2004-09-27 15:23:42 UTC 
Fixed.
Comment 3 Martin Schovanek 2005-11-18 15:35:09 UTC 
Verified