[ https://issues.apache.org/jira/browse/TRAFODION-3279?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
He Zhenxing updated TRAFODION-3279: ----------------------------------- Description: When mixing lob and normal columns like this: {noformat} >> cqd traf_blob_as_varchar 'off'; >> create table t1 (a int, b blob); >> create table t2 (a blob, b int, c blob); {noformat} try get lob stats will fail with this error: {noformat} >> 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. {noformat} 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. was: When mixing lob and normal columns like this: {noformat} >> cqd traf_blob_as_varchar 'off'; >> create table t1 (a int, b blob); >> create table t2 (a blob, b int, c blob); {noformat} try get lob stats will fail with this error: {noformat} >> 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. {noformat} It seems it will wrongly treat the normal columns before blob column as a blob column. > get lob stats fail when mixing lob and normal columns > ----------------------------------------------------- > > Key: TRAFODION-3279 > URL: https://issues.apache.org/jira/browse/TRAFODION-3279 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-exe > Affects Versions: any > Reporter: He Zhenxing > Priority: Minor > Fix For: 2.3 > > > When mixing lob and normal columns like this: > {noformat} > >> cqd traf_blob_as_varchar 'off'; > >> create table t1 (a int, b blob); > >> create table t2 (a blob, b int, c blob); > {noformat} > try get lob stats will fail with this error: > {noformat} > >> 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. > {noformat} > 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. -- This message was sent by Atlassian JIRA (v7.6.3#76005)