partition information is not being set up correctly for tables with delimited names

Bug #1418685 reported by Anoop Sharma
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
Fix Committed
Medium
Anoop Sharma

Bug Description

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.
>>

Tags: sql-cmp
Changed in trafodion:
status: In Progress → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.