Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-2044

CREATE TABLE LIKE with SALT USING clause uses source table partition count

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0-incubating
    • Fix Version/s: 2.1-incubating
    • Component/s: sql-cmu
    • Labels:
      None
    • Environment:
      Trafodion 2.0 environment

      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

        Attachments

          Activity

            People

            • Assignee:
              dbirdsall Dave Birdsall
              Reporter:
              carolp222 Carol Pearson
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: