[jira] [Created] (TRAFODION-832) LP Bug: 1403615 - Erroneous handling of the table name HISTOGRAMS

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

Alice Chen created TRAFODION-832:
------------------------------------

             Summary: LP Bug: 1403615 - Erroneous handling of the table name HISTOGRAMS
                 Key: TRAFODION-832
                 URL: https://issues.apache.org/jira/browse/TRAFODION-832
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Weishiun Tsai
            Assignee: Anoop Sharma


In Trafodion, histogram tables have been renamed to SB_HISTOGRAMS and SB_HISTOGRAM_INTERVALS.  The legacy name ‘HISTOGRAMS’ is supposedly not a reserved table name anymore, but it is being handled erroneously.   

Select from HISTOGRAMS returns an internal error no matter if the table exists or not.  Create table allows you to create it, but you can’t drop it.  It returns yet another internal error when attempting to drop it.  The schema where you create such a table becomes un-droppable once the table is created.

This is seen on the v1209_0830 build.

-----------------------------------------------------------------------------

Here is the entire script to reproduce this problem:

set schema MYTEST1;
select * from HISTOGRAMS;
create table HISTOGRAMS (a int);
select * from HISTOGRAMS;
drop table HISTOGRAMS;
drop schema MYTEST1 cascade;

-----------------------------------------------------------------------------

Here is the execution output:

>>set schema MYTEST1;

--- SQL operation complete.
>>select * from HISTOGRAMS;

*** ERROR[2006] Internal error: assertion failure (inTableDesc) in file ../optimizer/NATable.cpp at line 4933.

*** ERROR[8822] The statement was not prepared.

>>create table HISTOGRAMS (a int);

--- SQL operation complete.
>>select * from HISTOGRAMS;

*** ERROR[2006] Internal error: assertion failure (inTableDesc) in file ../optimizer/NATable.cpp at line 4933.

*** ERROR[8822] The statement was not prepared.

>>drop table HISTOGRAMS;

*** ERROR[2006] Internal error: assertion failure (inTableDesc) in file  at line -99999.

--- SQL operation failed with errors.
>>drop schema MYTEST1 cascade;

*** ERROR[1069] Schema TRAFODION.MYTEST1 could not be dropped.

--- SQL operation failed with errors.



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