Last 2 characters of a varchar string got truncated when the varchar column is bigger than 32K

Bug #1449343 reported by Jieping Zhang on 2015-04-28
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
Fix Released
Critical
Unassigned

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

tags: added: connectivity-mxosrvr
Changed in trafodion:
status: New → Fix Released
Changed in trafodion:
assignee: nobody → Arvind Narain (arvind-narain)
assignee: Arvind Narain (arvind-narain) → nobody
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers