[ 
https://issues.apache.org/jira/browse/TRAFODION-295?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14708668#comment-14708668
 ] 

Atanu Mishra commented on TRAFODION-295:
----------------------------------------

Anoop Sharma (anoop-sharma) wrote on 2014-08-20:        #2
fixed and committed:

>>create table t (a int not null primary key) salt using 4 partitions;

--- SQL operation complete.
>>showddl t;

CREATE TABLE TRAFODION.SCH.T
  (
    A INT NO DEFAULT NOT NULL NOT DROPPABLE
  , PRIMARY KEY (A ASC)
  )
  SALT USING 4 PARTITIONS
;

--- SQL operation complete.
>>insert into t values (1);

--- 1 row(s) inserted.
>>select * from t;

A
-----------

          1

--- 1 row(s) selected.
>>purgedata t;

--- SQL operation complete.
>>showddl t;

CREATE TABLE TRAFODION.SCH.T
  (
    A INT NO DEFAULT NOT NULL NOT DROPPABLE
  , PRIMARY KEY (A ASC)
  )
  SALT USING 4 PARTITIONS
;

--- SQL operation complete.
>>

Changed in trafodion:
status: In Progress → Fix Committed


> LP Bug: 1322400 - purgedata does not maintain number of salted partition 
> information
> ------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-295
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-295
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-exe
>            Reporter: Anoop Sharma
>            Assignee: Anoop Sharma
>            Priority: Critical
>             Fix For: 0.9 (pre-incubation)
>
>
> purgedata does not maintain number of salted partition information.
> It recreates it with 1 partition.



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

Reply via email to