partition information is not being set up correctly for tables with delimited names
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.
(
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.
(
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 |