[ https://issues.apache.org/jira/browse/TRAFODION-309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Atanu Mishra closed TRAFODION-309. ---------------------------------- Resolution: Fixed Assignee: (was: Anoop Sharma) > LP Bug: 1323878 - can't find table after add contraint primary key > ------------------------------------------------------------------ > > Key: TRAFODION-309 > URL: https://issues.apache.org/jira/browse/TRAFODION-309 > Project: Apache Trafodion > Issue Type: Bug > Reporter: Apache Trafodion > Priority: Critical > Fix For: 0.8 (pre-incubation) > > > 1) add constraint reportly complete without error > 2) showddl didn't display add constraint > 3) can't find table afterward. can't drop table because of that. > SQL>get tables; > Tables in Schema TRAFODION.DEBUG_DDL04 > ====================================== > > T1A011 > --- SQL operation complete. > SQL>alter table t1a011 add constraint ca011 primary key (ubin0_uniq ) > droppable; > --- SQL operation complete. > SQL>get tables; > --- SQL operation complete. > SQL>showddl t1a011; > > CREATE TABLE TRAFODION.DEBUG_DDL04.T1A011 > ( > SBIN0_10 NUMERIC(18, 0) NO DEFAULT NOT NULL NOT > DROPPABLE > , CHAR0_2 CHAR(8) CHARACTER SET ISO88591 COLLATE > DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE > , UDEC0_UNIQ DECIMAL(9, 0) UNSIGNED NO DEFAULT NOT > NULL > NOT DROPPABLE > , UBIN0_UNIQ NUMERIC(9, 0) UNSIGNED NO DEFAULT NOT > NULL > NOT DROPPABLE > , SDEC0_500 DECIMAL(9, 0) NO DEFAULT NOT NULL NOT > DROPPABLE > , VARCHAR0_10 VARCHAR(16) CHARACTER SET ISO88591 > COLLATE > DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE > , VARCHAR1_20 VARCHAR(8) CHARACTER SET ISO88591 COLLATE > DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE > , SBIN1_5000 NUMERIC(4, 0) NO DEFAULT NOT NULL NOT > DROPPABLE > , SDEC1_4 DECIMAL(18, 0) NO DEFAULT NOT NULL NOT > DROPPABLE > , CHAR1_4 CHAR(8) CHARACTER SET ISO88591 COLLATE > DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE > ) > STORE BY (UDEC0_UNIQ ASC) > ; > --- SQL operation complete. > SQL>-- fail to drop table > SQL>drop table t1a011; > *** ERROR[1389] Object TRAFODION.DEBUG_DDL04.T1A011 does not exist in > Trafodion. [2014-05-27 16:15:31] > SQL>drop table t1a011 cascade; > *** ERROR[1389] Object TRAFODION.DEBUG_DDL04.T1A011 does not exist in > Trafodion. [2014-05-27 16:15:31] > -- test script: > og a02log clear; > -- #testcase a01 altered table -add constraint > create schema TRAFODION.debug_ddl04; > set schema TRAFODION.debug_ddl04; > Create Table t1a011 > ( > sbin0_10 Numeric(18) signed not null, > char0_2 Character(8) not null, > udec0_uniq Decimal(9) unsigned not null, > ubin0_uniq PIC 9(9) COMP not null, > sdec0_500 PIC S9(9) not null, > varchar0_10 varchar(16) not null, > varchar1_20 varchar(8) not null, > sbin1_5000 Numeric(4) signed not null, > sdec1_4 Decimal(18) signed not null, > char1_4 Character(8) not null > > ) > store by (udec0_uniq) > ; > get tables; > alter table t1a011 add constraint ca011 primary key (ubin0_uniq ) droppable; > get tables; > showddl t1a011; > -- can't find table > drop table t1a011 cascade; > get tables; > alter table t1a011 drop constraint ca011; > select * from t1a011; > showddl t1a011; > drop table t1a011; > drop table t1a011 cascade; > log off; > exit; -- This message was sent by Atlassian JIRA (v6.3.4#6332)