disable index error displays incorrect schema name
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Fix Released
|
Medium
|
Roberta Marton |
Bug Description
build: 20150108
issue found while verifying fix for launchpad bug 1384479
table is created under one schema. alter table adds primary key constraint to table. when trying to alter table to disable indexes, an error is returned. moreover, the error message includes the incorrect (previously used) )schema name for the primary key constraint.
SQL>show schema;
SCHEMA SEABASE
SQL>showddl t1;
CREATE TABLE TRAFODION.
(
C1 INT NO DEFAULT NOT NULL NOT DROPPABLE
, C2 INT DEFAULT NULL
)
;
-- GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON TRAFODION.
--- SQL operation complete.
SQL>alter table t1 disable all indexes;
--- SQL operation complete.
SQL>alter table t1 enable all indexes;
--- SQL operation complete.
SQL>alter table t1 add constraint t1_pk primary key (c1);
--- SQL operation complete.
SQL>alter table t1 disable all indexes;
*** ERROR[1389] Object TRAFODION.
*** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry. [2015-01-09 12:03:03]
*** WARNING[1389] Object TRAFODION.
SQL>
To reproduce:
create table t1 (c1 int not null, c2 int);
insert into t1 values (1,1), (2,2);
alter table t1 add constraint t1_pk primary key (c1);
alter table t1 disable all indexes;
Changed in trafodion: | |
status: | New → Fix Released |