[
https://issues.apache.org/jira/browse/TRAFODION-2413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anoop Sharma reassigned TRAFODION-2413:
---------------------------------------
Assignee: Anoop Sharma
> row tatal length is wrongly calculated in Aligned format
> --------------------------------------------------------
>
> Key: TRAFODION-2413
> URL: https://issues.apache.org/jira/browse/TRAFODION-2413
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.1-incubating, 2.2-incubating
> Reporter: Eric Owhadi
> Assignee: Anoop Sharma
>
> Row_Total_Length as reported on db manager, or can be retrieved using
> following query is wrong for aligned format table. The logic used assumes
> wrongly that the table uses n aligned format. This has consequences beyond
> just information, but also for performance, internal buffers are wrongly over
> inflated, and BMO can spill to disk earlier than necessary:
> set schema "_MD_";
> -- Get the Object UID
> select * from objects where schema_name = 'MYSCHEMA' and object_name =
> 'MYTABLE';
> select * from tables where table_uid = 3146444098927464648;
> -- shows 630 as total row length
> -- display columns
> select column_name, column_number, sql_data_type, column_size
> from columns
> where object_uid = 3146444098927464648
> order by 2;
> -- shows same info as DBManager
> TABLE_UID ROW_FORMAT IS_AUDITED ROW_DATA_LENGTH
> ROW_TOTAL_LENGTH KEY_LENGTH NUM_SALT_PARTNS FLAGS
> -------------------- ---------- ---------- ---------------
> ---------------- ----------- --------------- --------------------
> 8556393311998525665 AF Y 51
> 630 37 4 0
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
