[jira] [Created] (TRAFODION-173) LP Bug: 1274646 - CREATE TABLE with large key and SALT USING giving error

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

Alice Chen created TRAFODION-173:
------------------------------------

             Summary: LP Bug: 1274646 - CREATE TABLE with large key and SALT USING giving error
                 Key: TRAFODION-173
                 URL: https://issues.apache.org/jira/browse/TRAFODION-173
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Guy Groulx
            Assignee: Hans Zeller


CREATE TABLE TRAFODION.TESTSCH.CPU (
	   SYSTEMNAME      CHAR(10) CHARACTER SET ISO88591  DEFAULT 'NAME' NOT NULL
	 , LOADID          CHAR(15) CHARACTER SET ISO88591  NO DEFAULT NOT NULL
	 , INITDATETIME    CHAR(14) CHARACTER SET ISO88591  NO DEFAULT NOT NULL
	 , LOADDATETIME    CHAR(14) CHARACTER SET ISO88591  NO DEFAULT NOT NULL
	 , NODEID          CHAR(15) CHARACTER SET ISO88591  NO DEFAULT NOT NULL
	 , SAMPLEDATETIME  CHAR(14) CHARACTER SET ISO88591  NO DEFAULT NOT NULL
	 , COLLECTMODE     CHAR(1)  CHARACTER SET ISO88591  NO DEFAULT NOT NULL
	 , CPUNUM          INT UNSIGNED  NO DEFAULT NOT NULL
	 , USERBUSY        FLOAT    NO DEFAULT NOT NULL
	 , NICEBUSY        FLOAT    NO DEFAULT NOT NULL
	 , SYSTEMBUSY      FLOAT    NO DEFAULT NOT NULL
	 , IDLETIME        FLOAT    NO DEFAULT NOT NULL
	 , TOTTIME         FLOAT    NO DEFAULT NOT NULL
	 , WAITTIME        FLOAT    NO DEFAULT NOT NULL
	 , IRQTIME         FLOAT    NO DEFAULT NOT NULL
	 , SOFTIRQTIME     FLOAT    NO DEFAULT NOT NULL
	 , STEALTIME       FLOAT    NO DEFAULT NOT NULL
	 , PRIMARY KEY (SYSTEMNAME ASC, LOADID ASC, INITDATETIME ASC, NODEID ASC
, LOADDATETIME ASC, SAMPLEDATETIME ASC, COLLECTMODE ASC, CPUNUM ASC)
	) SALT USING 16 PARTITIONS
	;

returns:
*** ERROR[8402] A string overflow occurred during the evaluation of a character expression. Conversion of Source Type:NCHAR VARYING(REC_NCHAR_V_UNICODE) Source Value:HASH2PARTFUNC(CAST(SYSTEMNAME AS CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT NOT NULL),CAST(LOADID AS CHAR(15) CHARACTER SET ISO88591 COLLATE DEFAULT NOT NULL),CAST(INITDATETIME AS CHAR(14) CHARA to Target Type:NCHAR VARYING(REC_NCHAR_V_UNICODE).

*** ERROR[8811] Trying to close a statement that is either not in the open state or has not reached EOF.

--- SQL operation failed with errors.



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