[jira] [Created] (TRAFODION-546) LP Bug: 1358352 - pcode issue- null field padded with zeros to the max length

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

Alice Chen created TRAFODION-546:
------------------------------------

             Summary: LP Bug: 1358352 - pcode issue- null field padded with zeros to the max length
                 Key: TRAFODION-546
                 URL: https://issues.apache.org/jira/browse/TRAFODION-546
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Apache Trafodion
            Assignee: Apache Trafodion
             Fix For: 0.9 (pre-incubation)


the convert expression that is boing used in ExHbaseIUD.cpp  (upsert and load)  pads the result null fields with '\0'  .
for example if the target column is 10 bytes in length and it has a null value the xpression set the null indicator to 0xFF
and also fill the 10 bytes with 0x00.
this only happens when pcode is enabled. when pcode is disabled the issue does not take place.

to reproduce you can create a trafodion source table srctable that has null values in the data. and a trafodion target table tgttale.
then run the statement upsert using load into <tgttable> select * from from <srctable>;

in hbase shell do a scan '<tgttable>'

you will see the null coluimns filled wuth 0x00
Assigned to LaunchPad User khaled Bouaziz



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