[TRAFODION-868] LP Bug: 1409113 - disable index error displays incorrect schema name

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1 (pre-incubation)
• Component/s: sql-cmu
• External issue URL: https://bugs.launchpad.net/bugs/1409113
• Assignee: Roberta Marton
• Reporter: Paul Low
• Created: 22/Jul/15 18:18
• Updated: 31/Aug/15 05:35
• Resolved: 31/Aug/15 05:35

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.SEABASE.T1
(
C1 INT NO DEFAULT NOT NULL NOT DROPPABLE
, C2 INT DEFAULT NULL
)
;

– GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON TRAFODION.SEABASE.T1 TO DB__ROOT WITH GRANT OPTION;

— 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.A28SCHEMA1.T1_PK does not exist in Trafodion. [2015-01-09 12:03:03]
    • 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.A28SCHEMA1.T1_PK does not exist in Trafodion. [2015-01-09 12:03:03]

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;