[jira] [Created] (TRAFODION-369) LP Bug: 1328642 - able to create volatile salt table, when no primary key or store-by key specified

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

Alice Chen created TRAFODION-369:
------------------------------------

             Summary: LP Bug: 1328642 - able to create volatile salt table, when no primary key or store-by key specified
                 Key: TRAFODION-369
                 URL: https://issues.apache.org/jira/browse/TRAFODION-369
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Julie Thai


Able to create volatile salt table, when no primary-key or store-by-key specified.

To reproduce:
-- expect ERROR[1195]
CREATE VOLATILE TABLE saltsyn( a int not null, b int not null, c int not null) SALT USING 4 PARTITIONS;
-- expect ERROR[4082]
INVOKE saltsyn;

On RC2 (0606_0930):
>>CREATE VOLATILE TABLE saltsyn( a int not null, b int not null, c int not null) SALT USING 4 PARTITIONS;

--- SQL operation complete.
>>invoke saltsyn;

-- Definition of Trafodion volatile table SALTSYN
-- Definition current  Tue Jun 10 18:14:44 2014

  (
    "_SALT_"                         INT UNSIGNED NO DEFAULT NOT NULL NOT
      DROPPABLE
  , SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  , A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
  , B                                INT NO DEFAULT NOT NULL NOT DROPPABLE
  , C                                INT NO DEFAULT NOT NULL NOT DROPPABLE
  )

--- SQL operation complete.



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