METRIC_QUERY_AGGR_TABLE - typo in DELTA_NUM_ROWS_UID - should be DELTA_NUM_ROWS_IUD to match the TOTAL_NUM_ROWS_IUD

Bug #1411776 reported by Aruna Sadashiva
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
Fix Committed
Medium
Anuradha

Bug Description

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.

Changed in trafodion:
milestone: none → r1.1
assignee: nobody → Anuradha (anuradha-hegde)
Revision history for this message
Anuradha (anuradha-hegde) wrote :

This will be addressed as part of repository upgrade for 1.1 release.

Changed in trafodion:
status: New → In Progress
Revision history for this message
Anuradha (anuradha-hegde) wrote :

Change delivered along with this delivery https://review.trafodion.org/#/c/1316/

Changed in trafodion:
status: In Progress → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.