Return-Path: Delivered-To: apmail-db-ddlutils-dev-archive@www.apache.org Received: (qmail 94007 invoked from network); 14 Nov 2005 20:02:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 14 Nov 2005 20:02:52 -0000 Received: (qmail 16881 invoked by uid 500); 14 Nov 2005 20:02:51 -0000 Delivered-To: apmail-db-ddlutils-dev-archive@db.apache.org Received: (qmail 16859 invoked by uid 500); 14 Nov 2005 20:02:51 -0000 Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-dev@db.apache.org Delivered-To: mailing list ddlutils-dev@db.apache.org Received: (qmail 16848 invoked by uid 99); 14 Nov 2005 20:02:51 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Nov 2005 12:02:49 -0800 Received: from ajax.apache.org (ajax.apache.org [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id 22EA2C9 for ; Mon, 14 Nov 2005 21:02:28 +0100 (CET) Message-ID: <1538635916.1131998548130.JavaMail.jira@ajax.apache.org> Date: Mon, 14 Nov 2005 21:02:28 +0100 (CET) From: "Thomas Dudziak (JIRA)" To: ddlutils-dev@db.apache.org Subject: [jira] Resolved: (DDLUTILS-47) An identity column should be an primary key In-Reply-To: <2136008441.1131996627958.JavaMail.jira@ajax.apache.org> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ http://issues.apache.org/jira/browse/DDLUTILS-47?page=all ] Thomas Dudziak resolved DDLUTILS-47: ------------------------------------ Resolution: Won't Fix Derby and othr databases support a special type of column - IDENTITY in Derby, autoincrement in MySQL - where the database automatically determines the value of the column if not explicitly specified. You're right that most of the time this is only applicable to primary key columns. However, this is not always the case. For databases like Oracle, the auto-increment is implemented via a sequence, and there is no requirement that the column need to be a primary key. Hence, you need to specify both autoincrement and primarykey for the column for databases that require it. > An identity column should be an primary key > ------------------------------------------- > > Key: DDLUTILS-47 > URL: http://issues.apache.org/jira/browse/DDLUTILS-47 > Project: DdlUtils > Type: Bug > Environment: Tested on Hsql and Derby > Reporter: Juliano Julio > Assignee: Thomas Dudziak > Priority: Blocker > > An identity column should be a primary key too! The method shouldGeneratePrimaryKeys on SqlBuilder don't allow this. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira