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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: sql-cmu
• External issue URL: https://bugs.launchpad.net/bugs/1385543
• Assignee: Hans Zeller
• Reporter: Anoop Sharma
• Created: 22/Jul/15 18:17
• Updated: 31/Aug/15 05:35
• Resolved: 31/Aug/15 05:35

Description

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.
>>