[jira] [Created] (TRAFODION-240) LP Bug: 1312922 - merge command should not allow to update primary key values

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

Alice Chen created TRAFODION-240:
------------------------------------

             Summary: LP Bug: 1312922 - merge command should not allow to update primary key values
                 Key: TRAFODION-240
                 URL: https://issues.apache.org/jira/browse/TRAFODION-240
             Project: Apache Trafodion
          Issue Type: Bug
            Reporter: Apache Trafodion
            Assignee: Anoop Sharma
            Priority: Critical


>>create table mychar (col1 largeint not null,
+>  col2  char(10),
+>  col3  char(5),
+>  col4  char(20),
+>  primary key(col1));

--- SQL operation complete.

>>insert into mychar values
+>    (1,'AAAAAAAAAA','BBBBB','my longish string'),
+>    (2,'bbbbbbbbbb','ccccc','my second string');

>>merge into mychar on col1=2 when matched then
+>    update set (col1,col2)=(20,'a');

--- 1 row(s) updated.
>>



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