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)