You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/08/27 15:49:46 UTC
[jira] [Closed] (TRAFODION-1193) LP Bug: 1446802 - ODBC SQLFetch
fails when column size is bigger than 64K
[ https://issues.apache.org/jira/browse/TRAFODION-1193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah closed TRAFODION-1193.
-------------------------------------
> 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)