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
