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:20:21 UTC
[jira] [Created] (TRAFODION-1193) LP Bug: 1446802 - ODBC SQLFetch
fails when column size is bigger than 64K
Alice Chen created TRAFODION-1193:
-------------------------------------
Summary: LP Bug: 1446802 - ODBC SQLFetch fails when column size is bigger than 64K
Key: TRAFODION-1193
URL: https://issues.apache.org/jira/browse/TRAFODION-1193
Project: Apache Trafodion
Issue Type: Bug
Reporter: JiepingZhang
Assignee: Daniel Lu
Priority: Blocker
Fix For: 1.1 (pre-incubation)
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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)