[
https://issues.apache.org/jira/browse/TRAFODION-1209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14716682#comment-14716682
]
Suresh Subbiah commented on TRAFODION-1209:
-------------------------------------------
Jieping Zhang (jieping-zhang) on 2015-04-28
tags: added: connectivity-mxosrvr
Jieping Zhang (jieping-zhang) on 2015-05-04
Changed in trafodion:
status: New → Fix Released
Arvind Narain (arvind-narain) on 2015-05-08
Changed in trafodion:
assignee: nobody → Arvind Narain (arvind-narain)
assignee: Arvind Narain (arvind-narain) → nobody
> 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)
