[ 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)