-
Type:
Bug
-
Status: Closed
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.1 (pre-incubation)
-
Component/s: connectivity-mxosrvr
-
Labels:None
-
External issue URL:
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.