Message: A new issue has been created in JIRA.
--------------------------------------------------------------------- View the issue: http://issues.apache.org/jira/browse/DERBY-3 Here is an overview of the issue: --------------------------------------------------------------------- Key: DERBY-3 Summary: Identity column not filled consecutively with "insert ... select distinct" Type: Bug Status: Unassigned Priority: Major Project: Derby Assignee: Reporter: Christian d'Heureuse Created: Mon, 27 Sep 2004 10:32 AM Updated: Mon, 27 Sep 2004 10:32 AM Environment: Derby Snapshot svnversion 46005 or Cloudscape 10.0 GA Description: When an "insert ... select distinct" is used to fill a table with an identity column, gaps occur in the identity column. The caps correspond to the rows of the source table that have been suppressed with "distinct". Example: create table temp1 ( s varchar(10)); insert into temp1 values 'a','a','a','b','c','c','c','d'; create table temp2 ( i integer not null generated always as identity primary key, s varchar(10)); insert into temp2 (s) select distinct s from temp1; select * from temp2; output: 1 a 4 b 5 c 8 d --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
