[jira] [Created] (TRAFODION-167) LP Bug: 1271673 - Create view sees string overflow 8402 error on empty tables

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

Alice Chen created TRAFODION-167:
------------------------------------

             Summary: LP Bug: 1271673 - Create view sees string overflow 8402 error on empty tables
                 Key: TRAFODION-167
                 URL: https://issues.apache.org/jira/browse/TRAFODION-167
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-general
            Reporter: Weishiun Tsai
            Assignee: Hans Zeller


As shown below, create view sees string overflow 8402 error, even though the 2 tables involved are completely empty.  This is seen on the beta build trafodion-ci-release-trafodion_beta-20140117-v36857_release.tar running on a workstation installation.

>>create table  agtab3 ( e char(4), p char(6) );

--- SQL operation complete.
>>create table  agtab4 ( e char(4), p char(6) );

--- SQL operation complete.
>>create view agvy4 (e, p) as
+>( select * from agtab3
+>union all
+>select * from agtab4
+>union
+>select * from agtab3
+>union all
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>union
+>select * from agtab4
+>union
+>select * from agtab3
+>) ;

*** ERROR[8402] A string overflow occurred during the evaluation of a character expression. Conversion of Source Type:VARCHAR(REC_BYTE_V_ASCII) Source Value:CREATE VIEW TRAFODION.SEABASE.AGVY4 (E, P) AS (SELECT TRAFODION.SEABASE.AGTAB3.E, TRAFODION.SEABASE.AGTAB3.P FROM TRAFODION.SEABASE.AGTAB3 UNION ALL SELECT TRAFODION.SEABASE.AGTAB4.E, TRAFODION.SEABA to Target Type:VARCHAR(REC_BYTE_V_ASCII).

*** 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)