[jira] [Created] (TRAFODION-2044) CREATE TABLE LIKE with SALT USING clause uses source table partition count

["Carol Pearson (JIRA)" <ji...@apache.org>]

Carol Pearson created TRAFODION-2044:
----------------------------------------

             Summary: CREATE TABLE LIKE with SALT USING  clause uses source table partition count
                 Key: TRAFODION-2044
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2044
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmu
    Affects Versions: 2.0-incubating
         Environment: Trafodion 2.0 environment
            Reporter: Carol Pearson
            Assignee: David Wayne Birdsall
             Fix For: 2.1-incubating


Using CREATE TABLE LIKE to create a table, then changing the number of partitions. The resulting new table number of partitions matches the partitioncount for the source table in the CREATE TABLE LIKE statement, rather than the value specified in the command:

See the following commands:

>>>create table tsource (c1 int not null, c2 int not null, primary key (c1))
+>salt using 4 partitions;

--- SQL operation complete.
>>create table tsource_like like tsource salt using 8 partitions;

--- SQL operation complete.
>>showddl tsource_like
+>;

CREATE TABLE TRAFODION.SEABASE.TSOURCE_LIKE
  (
    C1                               INT NO DEFAULT NOT NULL NOT DROPPABLE
      SERIALIZED
  , C2                               INT NO DEFAULT NOT NULL NOT DROPPABLE
      SERIALIZED
  , PRIMARY KEY (C1 ASC)
  )
  SALT USING 4 PARTITIONS
;

--- SQL operation complete.
>>

But table tsource_like was created using SALT USING 8 PARTITIONS




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