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:15:52 UTC

[jira] [Created] (TRAFODION-389) LP Bug: 1332607 - long cluster keys got internal error 2006

Alice Chen created TRAFODION-389:
------------------------------------

             Summary: LP Bug: 1332607 - long cluster keys got internal error 2006
                 Key: TRAFODION-389
                 URL: https://issues.apache.org/jira/browse/TRAFODION-389
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Apache Trafodion
            Assignee: Anoop Sharma
            Priority: Critical


when cluster keys are too long, got internal error 2006.

SQL>  create table t004t3 (
+>    i1 int,
+>    v2 varchar(4) not null,
+>    v3 varchar(128) not null,
+>    v5 varchar(1024) not null,
+>    primary key (v2, v3, v5) not droppable
+>  )
+>  ;

--- SQL operation complete.

SQL>  update t004t3 set i1 = 100
+>    where v2 in ('aa','dd','gg','jj','mm','pp');

*** ERROR[2006] Internal error: assertion failure (*bufLen >= getNominalSize() + getVarLenHdrSize()) in file ../common/CharType.cpp at line 1167. [2014-06-20 16:06:23]



-- test script:
  create table t004t3 (
    i1 int,
    v2 char(4) not null,
    v3 char(128) not null,
    v5 char(1024) not null,
    primary key (v2, v3, v5) not droppable
  )
  ;

  update t004t3 set i1 = 100
    where v2 in ('aa','dd','gg','jj','mm','pp');



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