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

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-794:
------------------------------------

             Summary: 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)