You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Steve Varnau (JIRA)" <ji...@apache.org> on 2015/11/30 18:04:11 UTC
[jira] [Reopened] (TRAFODION-736) LP Bug: 1389010 - ODBC API
SQLColAttributes returns wrong column numbers of table in GBK Unicode mode
[ https://issues.apache.org/jira/browse/TRAFODION-736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steve Varnau reopened TRAFODION-736:
------------------------------------
Re-opened on behalf of Rachel (Rui-Xian) Gao.
> LP Bug: 1389010 - ODBC API SQLColAttributes returns wrong column numbers of table in GBK Unicode mode
> -----------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-736
> URL: https://issues.apache.org/jira/browse/TRAFODION-736
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-odbc-linux
> Reporter: JiepingZhang
> Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> Table below has total of 29 columns, but somehow SQLColAttributes only returns 26 as the total column number of the table. This only happens in Unicode test, it can be reproduced via Coast SQLColumnAttribute tests.
> >> create table "ÃÃõÃôÃÃÃÃ÷Ãë¹ÃÃÃÃÃ1"("ÃÂAR(10) CHARACTER SET ISO88591,"á2" VARCHAR(10) CHARACTER SET ISO88591,"á3" DECIMAL(10,5),"4" DECIMAL(5,2) UNSIGNED,"á5" NUMERIC(10,5),"á6" NUMERIC(5,2) UNSIGNED,"á7" SMALLINT,"ÃÂSMALLINT UNSIGNED,"á9" INTEGER,"á10" INTEGER UNSIGNED,"á11" REAL,"á12" FLOAT,"á13" D PRECISION,"á14" DATE,"á15" TIME,"á16" TIMESTAMP,"á17" BIGINT,"á18" LONG VARCHAR CHAR SET ISO88591,"á19" NUMERIC(19,0),"á20" NUMERIC(19,6),"á21" NUMERIC(128,0),"á22" NUME128,128),"á23" NUMERIC(128,64),"á24" NUMERIC(10,5) UNSIGNED,"á25" NUMERIC(18,5) UNSIGNED¡26" NUMERIC(30,10) UNSIGNED,"á27" CHAR(10) CHARACTER SET utf8,"á28" VARCHAR(10) CHARACTEET utf8,"á29" LONG VARCHAR CHARACTER SET utf8) NO PARTITION;
> Test failed at:
> 18:12:32 SQLColAttributes: Positive test for column 1
> 2
> ***ERROR: Column C1 & ColAtt SQL_COLUMN_COUNT, Line = 316
> ***ERROR: rgbDesc Expected: '' Actual: '', Line = 317
> ***ERROR: pcbDesc Expected: 0 Actual: 0, Line = 318
> ***ERROR: pfDesc Expected: 29 Actual: 26, Line = 320
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)