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)