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

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-868:
------------------------------------

             Summary: LP Bug: 1409113 - disable index error displays incorrect schema name
                 Key: TRAFODION-868
                 URL: https://issues.apache.org/jira/browse/TRAFODION-868
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmu
            Reporter: Paul Low
            Assignee: Roberta Marton
             Fix For: 1.1 (pre-incubation)


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;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)