You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:17:59 UTC

[jira] [Created] (TRAFODION-736) LP Bug: 1389010 - ODBC API SQLColAttributes returns wrong column numbers of table in GBK Unicode mode

Alice Chen created TRAFODION-736:
------------------------------------

             Summary: 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)