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

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 1.1 (pre-incubation)
• Component/s: connectivity-mxosrvr
• External issue URL: https://bugs.launchpad.net/bugs/1449343
• Assignee: Arvind Narain
• Reporter: JiepingZhang
• Created: 22/Jul/15 18:20
• Updated: 27/Aug/15 13:46
• Resolved: 27/Aug/15 13:45

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.