[jira] [Created] (TRAFODION-2072) long char columns cause non-deterministic behavior

["Anoop Sharma (JIRA)" <ji...@apache.org>]

Anoop Sharma created TRAFODION-2072:
---------------------------------------

             Summary: long char columns cause non-deterministic behavior 
                 Key: TRAFODION-2072
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2072
             Project: Apache Trafodion
          Issue Type: Bug
            Reporter: Anoop Sharma
            Assignee: Anoop Sharma


If a table has char/varchar columns that are more than 32K,
they show non-deterministic behavior.
This may show up for hbase format, aligned format or hive
tables.
Sometimes columns are truncated at 2-byte boundary,
sometimes large columns may cause hangs or other issues.

In the example below, the select hangs:

>>cqd traf_max_character_col_length '1000000';

--- SQL operation complete.
>>create table tlvc2 (z int, b char(10), c varchar(100000), a varchar(1000000))
+>   attribute aligned format;

--- SQL operation complete.
>>
>>insert into tlvc2 values (1, 'abc', repeat('a', 100000), repeat ('b', 100000));

--- 1 row(s) inserted.
>>
>>select char_length(a) from tlvc2;





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