[jira] [Created] (TRAFODION-2764) LOAD and UNLOAD statements with LOB columns cause runtime errors

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

Suresh Subbiah created TRAFODION-2764:
-----------------------------------------

             Summary: LOAD and UNLOAD statements with LOB columns cause runtime errors
                 Key: TRAFODION-2764
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2764
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
    Affects Versions: 2.1-incubating
            Reporter: Suresh Subbiah
            Assignee: Suresh Subbiah
            Priority: Minor
             Fix For: 2.2-incubating


LOAD and UNLOAD involving LOB columns is currently not supported. However they are not disallowed in the compiler. This causes strange errors to be seen at runtime. Sometimes success is reported and no rows are loaded, sometime we get an error saying HFile is not found.

With this change we will raise these compiler errors for LOAD and UNLOAD, when LOB columns are involved. If LOB is treated as a VARCHAR then this change will not apply.

control query default TRAF_BLOB_AS_VARCHAR 'OFF';
control query default TRAF_CLOB_AS_VARCHAR 'OFF';
create table myt1 (c1 blob, c2 clob);
create table myt2 like myt1 ;
insert into myt1 values ('column 1', 'column 2');
load into myt2 select * from myt1 ;

*** ERROR[4494] LOAD is not supported on a table with LOB columns. Table TRAFODION.SEABASE.MYT2 has LOB column C1.

*** ERROR[8822] The statement was not prepared.

unload into '/bulkload' select * from myt1 ;

*** ERROR[4495] UNLOAD is not supported on a SELECT with LOB columns. TRAFODION.SEABASE.MYT1.C2 is a LOB column.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)