[jira] [Created] (TRAFODION-1222) LP Bug: 1451618 - MXOSRVR returns trunctated string to clients

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-1222:
-------------------------------------

             Summary: LP Bug: 1451618 - MXOSRVR returns trunctated string to clients
                 Key: TRAFODION-1222
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1222
             Project: Apache Trafodion
          Issue Type: Bug
          Components: connectivity-mxosrvr
            Reporter: JiepingZhang
            Assignee: Tharak Capirala
            Priority: Critical
             Fix For: 2.0-incubating


When a table has varchar column and the varchar column size is defined bigger than 32K, MXOSRVR server may return truncted string to client application in certain circumstances.

Circumstance 1:
varchar column is defined as "Not NULL", length of the string stored in the varchar column < 32K, then MXOSRVR will truncate the last 2 characters of the string.
Eg:
    CREATE TABLE T1 ( C1 varchar (200000) NOT NULL);
    insert into T1 values ('aaaaaaaaaaaaaaaaaaaEE');
    select * from T1;  -->  MXOSRVR will truncate the last 2 characters 'EE', returns 'aaaaaaaaaaaaaaaaaaa' to clients.
        

Circumstance 2:
varchar column is defined as "Not NULL", length of the string stored in the varchar column > 32K, then MXOSRVR can only return the first 3392 characters to client application.
Eg:
    CREATE TABLE T1 ( C1 varchar (200000) NOT NULL);
    insert into T1 with a sting longer than 32768 characters
    select * from T1;  -> MXOSRVR only returns the first 3392 characters.

Circumstance 3:
varchar column is defined as "NULLABLE", length of the string stored in the varchar column > 32K, then MXOSRVR will truncate the last 2 characters of the string.
Eg:
    CREATE TABLE T1 ( C1 varchar (200000));
    insert into T1 with a sting longer than 32768 characters
    select * from T1;  -> MXOSRVR will truncate the last 2 characters of the string.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)