[
https://issues.apache.org/jira/browse/TRAFODION-240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14706318#comment-14706318
]
Atanu Mishra commented on TRAFODION-240:
----------------------------------------
Anoop Sharma (anoop-sharma) on 2014-05-30
Changed in trafodion:
status: In Progress → Fix Committed
ying-wen ku (ying-wen-ku) on 2014-06-05
Changed in trafodion:
status: Fix Committed → Fix Released
> 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
> Fix For: 0.8 (pre-incubation)
>
>
> >>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)
