[jira] Created: (DERBY-3) Identity column not filled consecutively with "insert ... select distinct"

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