[jira] [Closed] (TRAFODION-149) LP Bug: 1250183 - Clustering key conflicts with primary keys

["Atanu Mishra (JIRA)" <ji...@apache.org>]

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

Atanu Mishra closed TRAFODION-149.
----------------------------------
       Resolution: Fixed
         Assignee:     (was: Anoop Sharma)
    Fix Version/s: 0.8 (pre-incubation)

> LP Bug: 1250183 - Clustering key conflicts with primary keys
> ------------------------------------------------------------
>
>                 Key: TRAFODION-149
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-149
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-general
>            Reporter: Weishiun Tsai
>            Priority: Critical
>             Fix For: 0.8 (pre-incubation)
>
>
> When specifying STORE BY in a query together with PRIMARY KEY, the STORE BY seems to overwrite the PRIMARY KEY list.  The following example executes fine on SQ, but it gets an 8102 unique constraint error on Traf:
> >>set schema seabase.mytest;
> --- SQL operation complete.
> >>create table t (a int not null, b int not null, c int not null, d int, primary
>  key (a, b, c)) store by (a);
> --- SQL operation complete.
> >>insert into t values (1, 1, 1, 1), (1, 2, 2, 2);
> *** ERROR[8102] The operation is prevented by a unique constraint.
> --- 0 row(s) inserted.



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