[jira] [Closed] (TRAFODION-981) LP Bug: 1418685 - partition information is not being set up correctly for tables with delimited names

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah closed TRAFODION-981.
------------------------------------
    Resolution: Fixed

Close issues in JIRA to reflect status in LaunchPad

> LP Bug: 1418685 - partition information is not being set up correctly for tables with delimited names
> -----------------------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-981
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-981
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>            Reporter: Anoop Sharma
>            Assignee: Anoop Sharma
>             Fix For: 1.1 (pre-incubation)
>
>
> Number of actual partitions is not being retrieved correctly for delimited salted tables.
> In the first example below, number of actual partitions show up as 1 instead of 4.
> In the second example, it correctly shows up as 4.
> Trafodion Conversational Interface 1.0.0
> (c) Copyright 2014 Hewlett-Packard Development Company, LP.
> >>create table "abc" (a int not null primary key) salt using 4 partitions;
> --- SQL operation complete.
> >>showddl "abc";
> CREATE TABLE TRAFODION.SEABASE."abc"
>   (
>     A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
>   , PRIMARY KEY (A ASC)
>   )
>   SALT USING 4 PARTITIONS /* ACTUAL PARTITIONS 1 */
> ;
> --- SQL operation complete.
> >>create table abc (a int not null primary key) salt using 4 partitions;
> --- SQL operation complete.
> >>showddl abc;
> CREATE TABLE TRAFODION.SEABASE.ABC
>   (
>     A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
>   , PRIMARY KEY (A ASC)
>   )
>   SALT USING 4 PARTITIONS
> ;
> --- SQL operation complete.
> >>



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