[jira] [Commented] (TRAFODION-1883) Drop schema cascade fails when schema contains a table with LOB columns

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-1883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15195844#comment-15195844 ] 

ASF GitHub Bot commented on TRAFODION-1883:
-------------------------------------------

GitHub user sandhyasun opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/388

    TRAFODION-1883.Changes to drop LOB dependent tables during drop schema. 

    The LOB dependent tables were getting dropped before the actual LOB table was getting dropped in the dropSchema method. Changed that to drop these objects in 2 sequences to avoid this problem.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/sandhyasun/incubator-trafodion trafodion_1883

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/388.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #388
    
----

----


> Drop schema cascade fails when schema contains a table with LOB columns
> -----------------------------------------------------------------------
>
>                 Key: TRAFODION-1883
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1883
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-exe
>    Affects Versions: 2.0-incubating
>            Reporter: Sandhya Sundaresan
>            Assignee: Sandhya Sundaresan
>
> Drop schema cascade runs into an error and rollsback the transaction assocated with the drop schema. Without DDL transactions, the schema was left inconsistent. 
> To reproduce :
> Apache Trafodion Conversational Interface 2.0.0
> Copyright (c) 2015 Apache Software Foundation
> >>cqd ddl_transactions 'ON';
> --- SQL operation complete.
> >>cqd traf_blob_as_varchar 'OFF';
> --- SQL operation complete.
> >>create schema trafodion.lobsch;
> --- SQL operation complete.
> >>set schema trafodion.lobsch;
> --- SQL operation complete.
> >>create table tlob (c1 blob);
> --- SQL operation complete.
> >>get tables;
> Tables in Schema TRAFODION.LOBSCH
> =================================
> LOBDescChunks_09068089959276877228_0001
> LOBDescHandle_09068089959276877228_0001
> LOBMD_09068089959276877228
> SB_HISTOGRAMS
> SB_HISTOGRAM_INTERVALS
> TLOB
> --- SQL operation complete.
> >>drop schema trafodion.lobsch cascade;
> *** ERROR[1069] Schema TRAFODION.LOBSCH could not be dropped.
> *** ERROR[1073] Schema TRAFODION.LOBSCH was partially dropped, call CLEANUP SCHEMA to remove remaining entries.
> --- SQL operation failed with errors.
> >>get tables;
> Tables in Schema TRAFODION.LOBSCH
> =================================
> LOBDescChunks_09068089959276877228_0001
> LOBDescHandle_09068089959276877228_0001
> LOBMD_09068089959276877228
> SB_HISTOGRAMS
> SB_HISTOGRAM_INTERVALS
> TLOB
> --- SQL operation complete.
> >>



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