ODBC API SQLColAttributes returns wrong column numbers of table in GBK Unicode mode

Bug #1389010 reported by Jieping Zhang
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
Fix Released
High
Unassigned

Bug Description

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

tags: added: client-odbc-linux
Changed in trafodion:
status: New → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.