You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Gao, Rui-Xian (JIRA)" <ji...@apache.org> on 2015/12/10 13:21:11 UTC
[jira] [Updated] (TRAFODION-994) LP Bug: 1420523 - ODBC: Several
values returned by SQLColumns are incorrect
[ https://issues.apache.org/jira/browse/TRAFODION-994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gao, Rui-Xian updated TRAFODION-994:
------------------------------------
Description:
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
was:
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
> 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, sql-cmu
> Reporter: JiepingZhang
> Assignee: Sandhya Sundaresan
> Priority: Critical
> Fix For: 2.0-incubating
>
>
> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)