[
https://issues.apache.org/jira/browse/TRAFODION-1883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sandhya Sundaresan closed TRAFODION-1883.
-----------------------------------------
> 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
> Priority: Major
>
> 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
(v7.6.3#76005)
