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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0-incubating
• Fix Version/s: 2.1-incubating
• Component/s: sql-cmu
• Environment: Trafodion 2.0 environment
• Assignee: Dave Birdsall
• Reporter: Carol Pearson
• Created: 09/Jun/16 17:55
• Updated: 15/Sep/18 07:31
• Resolved: 08/Aug/16 23:38

Description

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

Issue Links

• links to: GitHub Pull Request #544
• links to: GitHub Pull Request #651