[jira] [Created] (TRAFODION-719) LP Bug: 1385543 - salt clause on a table with large number of primary key columns returns error

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

Alice Chen created TRAFODION-719:
------------------------------------

             Summary: LP Bug: 1385543 - salt clause on a table with large number of primary key columns returns error
                 Key: TRAFODION-719
                 URL: https://issues.apache.org/jira/browse/TRAFODION-719
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmu
            Reporter: Anoop Sharma
            Assignee: Hans Zeller


This create statement with 8 column pkey returns error.

>>  CREATE TABLE "O"."C1"
+>   (  "OM_REGION" VARCHAR2(20) NOT NULL,
+>      "OM_SYSTEM" VARCHAR2(20) DEFAULT '*' NOT NULL,
+>      "SALES" VARCHAR2(20) DEFAULT '*' NOT  NULL ,
+>      "RTM" VARCHAR2(20) DEFAULT '*' NOT NULL,
+>      "BT" VARCHAR2(20) DEFAULT '*' NOT NULL,
+>      "SEG" VARCHAR2(20) DEFAULT '*' NOT NULL,
+>      "SUB" VARCHAR2(20)     DEFAULT '*' NOT NULL,
+>       PRIMARY KEY ("OM_REGION", "OM_SYSTEM", "SALES", "RTM", "BT", "SEG", "SUB"))
+>       salt using 8 partitions;

*** ERROR[1197] The salt column list (implicit or explicit) is too long.

--- SQL operation failed with errors.
>>



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