[
https://issues.apache.org/jira/browse/TRAFODION-994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Selvaganesan Govindarajan updated TRAFODION-994:
------------------------------------------------
Fix Version/s: (was: 2.3)
2.4
> LP Bug: 1420523 - ODBC: Several values returned by SQLColumns are incorrect
> ---------------------------------------------------------------------------
>
> Key: TRAFODION-994
> URL: https://issues.apache.org/jira/browse/TRAFODION-994
> Project: Apache Trafodion
> Issue Type: Bug
> Components: connectivity-general
> Reporter: JiepingZhang
> Priority: Critical
> Fix For: 2.4
>
>
> Below are the failures in SQLColumn API testing:
> 1. In the resultset returned by SQLColumn API, value of column ColNullable is
> 2 rather than 1, column REMARK is empty.
> Test create table =>create table GTN2BSG5FQ (KXE2QSC7HC char(10) CHARACTER
> SET ISO88591) no partition
> =======================================================================
> SQLColumns: compare results of columns fetched for following column
> The Column Name is KXE2QSC7HC and column type is char
> ***ERROR: ColNullable expect: 1 and actual: 2 are not matched
> ***ERROR: Remark expect: CHARACTER CHARACTER SET ISO88591 and actual: are
> not matched
> Number of rows fetched: 1
> 2. Somehow if the table has more than 3 columns, the 3rd column seems got
> lost as nothing regarding the 3rd column is returned in the resultset. For
> test case below, 3rd column E5IPGXAHNB has no info in the resultset.
> 19:18:38 Test create table =>create table GTN2BSG5FQ (KXE2QSC7HC char(10)
> CHARACTER SET ISO88591,RMSYLIFAR4 varchar(10) CHARACTER SET
> ISO88591,E5IPGXAHNB long varchar CHARACTER SET ISO88591,ZQW9LNYDG3
> decimal(10,5)) no partition
> =======================================================================
> 19:18:40 SQLColumns: Test #3
> SQLColumns: SQLColumns function call executed correctly.
> SQLColumns: compare results of columns fetched for following column
> The Column Name is KXE2QSC7HC and column type is char
> ***ERROR: ColNullable expect: 1 and actual: 2 are not matched
> ***ERROR: Remark expect: CHARACTER CHARACTER SET ISO88591 and actual: are not
> matched
> SQLColumns: compare results of columns fetched for following column
> The Column Name is RMSYLIFAR4 and column type is varchar
> ***ERROR: ColNullable expect: 1 and actual: 2 are not matched
> ***ERROR: Remark expect: VARCHAR CHARACTER SET ISO88591 and actual: are not
> matched
> SQLColumns: compare results of columns fetched for following column
> The Column Name is E5IPGXAHNB and column type is long varchar
> ***ERROR: ColName expect: E5IPGXAHNB and actual: ZQW9LNYDG3 are not matched
> ***ERROR: ColDataType expect: 12 and actual: 3 are not matched
> ***ERROR: ColTypeName expect: VARCHAR and actual: DECIMAL are not matched
> ***ERROR: ColPrec expect: 2000 and actual: 10 are not matched
> ***ERROR: ColLen expect: 2000 and actual: 12 are not matched
> ***ERROR: ColScale expect: 0 and actual: 5 are not matched
> ***ERROR: ColRadix expect: 0 and actual: 10 are not matched
> ***ERROR: ColNullable expect: 1 and actual: 2 are not matched
> ***ERROR: Remark expect: VARCHAR CHARACTER SET ISO88591 and actual: are not
> matched
> Number of rows fetched: 3
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
