[ https://issues.apache.org/jira/browse/TRAFODION-3279?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Selvaganesan Govindarajan updated TRAFODION-3279: ------------------------------------------------- Fix Version/s: (was: 2.3) 2.4 > 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.4 > > > 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 (v8.3.4#803005)