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

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment