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

LP Bug: 1449343 - Last 2 characters of a varchar string got truncated when the varchar column is bigger than 32K

    XMLWordPrintableJSON

    Details

      Description

      Last 2 characters of a varchar string got truncated when the varchar column is equal to or bigger than 32k

      Steps to reproduce the problem:

      create table t23(c1 varchar(32768) not null, c2 char(1000) not null)
      insert into t23(c1, c2) values ('ssssssssssssssssssssssssssssssssssQAE','tttttttttttttttttttttttttttttE');
      select * from t23;

      From ODBC, you will see the returned value of c1 is "ssssssssssssssssssssssssssssssssssQ", the last 2 characters "AE" got truncated in SQLFetch.

      This also happens in TRAFCI, so seems it's a MXOSRVR side issue.

      SQL>select * from t23;

      C1 C2
      -------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
      ssssssssssssssssssssssssssssssssssQ tttttttttttttttttttttttttttttE

      — 1 row(s) selected.

        Attachments

          Activity

            People

            • Assignee:
              arvind.narain Arvind Narain
              Reporter:
              zhangjie JiepingZhang
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: