Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-1193

LP Bug: 1446802 - ODBC SQLFetch fails when column size is bigger than 64K

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.1 (pre-incubation)
    • Component/s: None
    • Labels:
      None

      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".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

        Attachments

          Activity

            People

            • Assignee:
              daniellu Daniel Lu
              Reporter:
              zhangjie JiepingZhang
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: