[TRAFODION-1193] LP Bug: 1446802 - ODBC SQLFetch fails when column size is bigger than 64K

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 1.1 (pre-incubation)
• External issue URL: https://bugs.launchpad.net/bugs/1446802
• Assignee: Daniel Lu
• Reporter: JiepingZhang
• Created: 22/Jul/15 18:20
• Updated: 27/Aug/15 13:49
• Resolved: 27/Aug/15 13:49

Description

SQLFetch returned error "[TRAF][Trafodion ODBC Driver] Cardinality violation; parameter value list does not match column list.Inconsistent memory offsets, data length, and rows fetched" when column size is bigger than 64K

To reproduce the problem, do the fetch below in ODBCTest:
SQLExecDirect:
In: Statementhandle = 0x000000000020AF40, StatementText = "select left (query_text,8192) from "REPOS".metri...", Statementlength = 64
Return: SQL_SUCCESS=0
SQLFetch:
In: StatementHandle = 0x000000000020AF40
Return: SQL_ERROR=-1
stmt: szSqlState = "21002", *pfNativeError = 0, *pcbErrorMsg = 159, *ColumnNumber = -1, *RowNumber = -2
MessageText = "[TRAF][Trafodion ODBC Driver] Cardinality violation; parameter value list does not match column list.Inconsistent memory offsets, data length, and rows fetched"
stmt: szSqlState = "S1000", *pfNativeError = 0, *pcbErrorMsg = 49, *ColumnNumber = -1, *RowNumber = -2
MessageText = "[TRAF][Trafodion ODBC Driver] Data type mismatch."

Data type of query_text: VARCHAR(50000 CHARS) CHARACTER SET UTF8