Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-2632

Performing update statistics on metadata tables causes issues

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: sql-general
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              anoopsharma Anoop Sharma
              Reporter:
              rmarton Roberta Marton
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: