[
https://issues.apache.org/jira/browse/TRAFODION-2764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah resolved TRAFODION-2764.
---------------------------------------
Resolution: Fixed
> 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)
