[TRAFODION-3279] get lob stats fail when mixing lob and normal columns

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: any
• Fix Version/s: 2.4
• Component/s: sql-exe
• Assignee: Unassigned
• Reporter: He Zhenxing
• Created: 21/Feb/19 08:48
• Updated: 16/Apr/20 02:19

Description

When mixing lob and normal columns like this:

>> cqd traf_blob_as_varchar 'off';
>> create table t1 (a int, b blob);
>> create table t2 (a blob, b int, c blob);

try get lob stats will fail with this error:

>> get lob stats for table t1

*** ERROR[4082] Object TRAFODION.SCH."LOBDescChunks__02697841542402152109_0001" does not exist or is inaccessible.

*** ERROR[8822] The statement was not prepared.

--- SQL operation failed with errors.
>>  get lob stats for table t2

*** ERROR[4082] Object TRAFODION.SCH."LOBDescChunks__02697841542402158348_0002" does not exist or is inaccessible.

*** ERROR[8822] The statement was not prepared.

--- SQL operation failed with errors.

It seems it will wrongly used the lob number as the lob column number.

Please note that showddl <table>, lob detail command is not affected, but select * from table(lob stats(<table>)) suffer the same problem.