[TRAFODION-1259] LP Bug: 1461255 - mtserver - ODBC SQLFetch not working when Trafodion enables MTDCS server

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Component/s: connectivity-general
• External issue URL: https://bugs.launchpad.net/bugs/1461255
• Assignee: Rao Kakarlamudi
• Reporter: JiepingZhang
• Created: 22/Jul/15 18:20
• Updated: 06/Mar/18 16:18

Description

ODBC SQLFetch fails when Trafodion enables MTDCS server, SQLFetch got error below:

SQLPrepare:
In: StatementHandle = 0x00000000005AB0C0, StatementText = "select * from jp_T6", TextLength = 19
Return: SQL_SUCCESS=0
SQLExecute:
In: StatementHandle = 0x00000000005AB0C0
Return: SQL_SUCCESS=0
SQLFetch:
In: StatementHandle = 0x00000000005AB0C0
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."