You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:20:25 UTC
[jira] [Created] (TRAFODION-1209) LP Bug: 1449343 - Last 2
characters of a varchar string got truncated when the varchar column is
bigger than 32K
Alice Chen created TRAFODION-1209:
-------------------------------------
Summary: LP Bug: 1449343 - Last 2 characters of a varchar string got truncated when the varchar column is bigger than 32K
Key: TRAFODION-1209
URL: https://issues.apache.org/jira/browse/TRAFODION-1209
Project: Apache Trafodion
Issue Type: Bug
Components: connectivity-mxosrvr
Reporter: JiepingZhang
Priority: Blocker
Fix For: 1.1 (pre-incubation)
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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)