[
https://issues.apache.org/jira/browse/TRAFODION-240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-240.
----------------------------------
Resolution: Fixed
Assignee: (was: Anoop Sharma)
Fix Version/s: 0.8 (pre-incubation)
> 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
> 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)
