Eric Owhadi created TRAFODION-2413:
--------------------------------------
Summary: 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
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)
