You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Roberta Marton (JIRA)" <ji...@apache.org> on 2017/06/02 22:59:04 UTC

[jira] [Created] (TRAFODION-2632) Performing update statistics on metadata tables causes issues

Roberta Marton created TRAFODION-2632:
-----------------------------------------

             Summary: Performing update statistics on metadata tables causes issues
                 Key: TRAFODION-2632
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2632
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-general
            Reporter: Roberta Marton


When schemas are created, Trafodion also creates histogram tables.  However, for metadata tables in schemas such as "_MD_" and "_PRIVMGR_MD_" these tables are not created.  Later on, someone can update statistics on one of these tables and the histogram tables are created.  This causes issues later on when cleaning up these tables, for example "initiailize authorization, drop" will fail.   Trafodion should not allow update statistics on metadata tables at this time.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)