[jira] [Created] (TRAFODION-901) LP Bug: 1411776 - METRIC_QUERY_AGGR_TABLE - typo in DELTA_NUM_ROWS_UID - should be DELTA_NUM_ROWS_IUD to match the TOTAL_NUM_ROWS_IUD

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

Alice Chen created TRAFODION-901:
------------------------------------

             Summary: LP Bug: 1411776 - METRIC_QUERY_AGGR_TABLE - typo in DELTA_NUM_ROWS_UID - should be DELTA_NUM_ROWS_IUD to match the TOTAL_NUM_ROWS_IUD
                 Key: TRAFODION-901
                 URL: https://issues.apache.org/jira/browse/TRAFODION-901
             Project: Apache Trafodion
          Issue Type: Bug
          Components: connectivity-dcs
            Reporter: Aruna Sadashiva
            Assignee: Anuradha Hegde
             Fix For: 1.1 (pre-incubation)


Typo in _REPOS_ metadata table METRIC_QUERY_AGGR_TABLE. 
DELTA_NUM_ROWS_UID should be DELTA_NUM_ROWS_IUD to match TOTAL_NUM_ROWS_IUD. 

SQL>showddl  TRAFODION."_REPOS_".metric_query_aggr_table;


CREATE TABLE TRAFODION."_REPOS_".METRIC_QUERY_AGGR_TABLE
  (
    ……
  , TOTAL_EST_ROWS_ACCESSED          LARGEINT DEFAULT NULL
  , TOTAL_EST_ROWS_USED              LARGEINT DEFAULT NULL
  , TOTAL_ROWS_RETRIEVED             LARGEINT DEFAULT NULL
  , TOTAL_NUM_ROWS_IUD               LARGEINT DEFAULT NULL
  , TOTAL_SELECTS                    LARGEINT DEFAULT NULL
  , TOTAL_INSERTS                    LARGEINT DEFAULT NULL
  , TOTAL_UPDATES                    LARGEINT DEFAULT NULL
  , TOTAL_DELETES                    LARGEINT DEFAULT NULL
  , DELTA_ESTIMATED_ROWS_ACCESSED    LARGEINT DEFAULT NULL
  , DELTA_ESTIMATED_ROWS_USED        LARGEINT DEFAULT NULL
  , DELTA_ROWS_ACCESSED              LARGEINT DEFAULT NULL
  , DELTA_ROWS_RETRIEVED             LARGEINT DEFAULT NULL
  , DELTA_NUM_ROWS_UID               LARGEINT DEFAULT NULL
  , DELTA_TOTAL_SELECTS              LARGEINT DEFAULT NULL
  , DELTA_TOTAL_INSERTS              LARGEINT DEFAULT NULL
 , DELTA_TOTAL_UPDATES              LARGEINT DEFAULT NULL
  , DELTA_TOTAL_DELETES              LARGEINT DEFAULT NULL
  , PRIMARY KEY (SESSION_ID ASC)
  )
  SALT USING 8 PARTITIONS /* ACTUAL PARTITIONS 1 */
;

--- SQL operation complete.



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