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-25) INSERT INTO SELECT DISTINCT ... skips some values for autoincrement column
Date Thu, 30 Sep 2004 20:23:40 GMT
Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:
  http://issues.apache.org/jira/browse/DERBY-25

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: DERBY-25
    Summary: INSERT INTO SELECT DISTINCT ... skips some values for autoincrement column
       Type: Bug

     Status: Unassigned
   Priority: Minor

    Project: Derby
 Components: 
             SQL
   Versions:
             10.0.2.0

   Assignee: 
   Reporter: Tulika Agrawal

    Created: Thu, 30 Sep 2004 1:23 PM
    Updated: Thu, 30 Sep 2004 1:23 PM

Description:
Reporting for Mamta Satoor.

If we use insert into desttable, select 
distinct from source, into a desttable which has autoincrement 
column in it, we might see gaps in the autoincrement column if 
there are duplicated rows in the source table. The reason for 
this is Derby projects values into destination table columns before 
building a distinct resultset from the source table. The piece 
of code doing this is in org.apache.derby.impl.sql.execute.ProjectRestrictResultSet class's
getNextRowCore() method where it calls doProjection. 




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


Mime
View raw message