You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/08/31 02:54:46 UTC

[jira] [Closed] (TRAFODION-794) LP Bug: 1396683 - Duplicate values can occur for the sequence generator identity column

     [ https://issues.apache.org/jira/browse/TRAFODION-794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah closed TRAFODION-794.
------------------------------------

> LP Bug: 1396683 - Duplicate values can occur for the sequence generator identity column
> ---------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-794
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-794
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: dtm
>            Reporter: Joanie Cooper
>            Assignee: Joanie Cooper
>            Priority: Blocker
>             Fix For: 1.0 (pre-incubation)
>
>
> While running the SQL regression test, seabase/TEST025, the T025T006 "upsert using load" DML statement succeeds, but can contain duplicate values in the sequence generator identity column.  
> These values should always be unique.
> Multiple ESP's are writing to the sequence generator table in parallel.  Each write should have DTM transaction protection.
> We need to determine which area of the Trafodion stack is experiencing the problem and resolve the issue.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)