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

["Sandhya Sundaresan (JIRA)" <ji...@apache.org>]

Sandhya Sundaresan created TRAFODION-1883:
---------------------------------------------

             Summary: 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)