[ 
https://issues.apache.org/jira/browse/TRAFODION-2632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Anoop Sharma reassigned TRAFODION-2632:
---------------------------------------

    Assignee: Anoop Sharma

> 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
>            Assignee: Anoop Sharma
>
> 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)

Reply via email to