db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From derby-...@db.apache.org
Subject [jira] Created: (DERBY-3) Identity column not filled consecutively with "insert ... select distinct"
Date Mon, 27 Sep 2004 17:32:32 GMT

  A new issue has been created in JIRA.

View the issue:

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

   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

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".


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;

 1   a
 4   b
 5   c
 8   d

This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:

If you want more information on JIRA, or have a bug to report see:

View raw message