You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Sandhya Sundaresan (JIRA)" <ji...@apache.org> on 2016/03/09 19:54:41 UTC
[jira] [Resolved] (TRAFODION-1763) LOB: Drop schema cascade fails
with LOB tables
[ https://issues.apache.org/jira/browse/TRAFODION-1763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sandhya Sundaresan resolved TRAFODION-1763.
-------------------------------------------
Resolution: Duplicate
> LOB: Drop schema cascade fails with LOB tables
> -----------------------------------------------
>
> Key: TRAFODION-1763
> URL: https://issues.apache.org/jira/browse/TRAFODION-1763
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Affects Versions: 1.3-incubating
> Reporter: Weishiun Tsai
> Assignee: Sandhya Sundaresan
>
> Drop schema cascade would often fail when there are LOB tables in the schema. This was seen on the v0115 build:
> >>control query default TRAF_BLOB_AS_VARCHAR 'OFF';
> --- SQL operation complete.
> >>control query default TRAF_CLOB_AS_VARCHAR 'OFF';
> --- SQL operation complete.
> >>
> >>create schema mytest;
> --- SQL operation complete.
> >>set schema mytest;
> --- SQL operation complete.
> >>
> >>create table t1 (c1 blob, c2 clob);
> --- SQL operation complete.
> >>drop table t1;
> --- SQL operation complete.
> >>create table t1 (c1 blob, c2 clob);
> --- SQL operation complete.
> >>
> >>create table t2 (c1 blob, c2 clob);
> --- SQL operation complete.
> >>drop table t2 cascade;
> --- SQL operation complete.
> >>create table t2 (c1 blob, c2 clob);
> --- SQL operation complete.
> >>
> >>get tables;
> Tables in Schema TRAFODION.MYTEST
> =================================
> LOBDescChunks_02733772491394077848_0001
> LOBDescChunks_02733772491394077848_0002
> LOBDescChunks_02733772491394083286_0001
> LOBDescChunks_02733772491394083286_0002
> LOBDescHandle_02733772491394077848_0001
> LOBDescHandle_02733772491394077848_0002
> LOBDescHandle_02733772491394083286_0001
> LOBDescHandle_02733772491394083286_0002
> LOBMD_02733772491394077848
> LOBMD_02733772491394083286
> T1
> T2
> --- SQL operation complete.
> >>
> >>drop schema mytest cascade;
> *** ERROR[1069] Schema TRAFODION.MYTEST could not be dropped.
> --- SQL operation failed with errors.
> ==============================================
> Here is the entire script to reproduce it:
> control query default TRAF_BLOB_AS_VARCHAR 'OFF';
> control query default TRAF_CLOB_AS_VARCHAR 'OFF';
> create schema mytest;
> set schema mytest;
> create table t1 (c1 blob, c2 clob);
> drop table t1;
> create table t1 (c1 blob, c2 clob);
> create table t2 (c1 blob, c2 clob);
> drop table t2 cascade;
> create table t2 (c1 blob, c2 clob);
> get tables;
> drop schema mytest cascade;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)