ODBC SQLFetch fails when column size is bigger than 64K
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Fix Released
|
Critical
|
Daniel Lu |
Bug 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_
Return: SQL_SUCCESS=0
SQLFetch:
In: StatementHandle = 0x000000000020AF40
Return: SQL_ERROR=-1
stmt: szSqlState = "21002", *pfNativeError = 0, *pcbErrorMsg = 159, *ColumnNumber = -1, *RowNumber = -2
stmt: szSqlState = "S1000", *pfNativeError = 0, *pcbErrorMsg = 49, *ColumnNumber = -1, *RowNumber = -2
Data type of query_text: VARCHAR(50000 CHARS) CHARACTER SET UTF8
Changed in trafodion: | |
assignee: | nobody → Daniel Lu (ping-lu) |
Changed in trafodion: | |
status: | New → Fix Committed |
this fix corresponding to server side fix "Fix for bug 1438775". without it, client will report "Cardinality violation; parameter value list does not match column list.Inconsistent memory offsets, data length, and rows fetched".