You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:17:09 UTC

[jira] [Created] (TRAFODION-487) LP Bug: 1350540 - DROP SCHEMA CASCADE not dropping SPJs and libraries.

Alice Chen created TRAFODION-487:
------------------------------------

             Summary: LP Bug: 1350540 - DROP SCHEMA CASCADE not dropping SPJs and libraries.
                 Key: TRAFODION-487
                 URL: https://issues.apache.org/jira/browse/TRAFODION-487
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmu
            Reporter: Aruna Sadashiva
            Assignee: Cliff Gray
            Priority: Critical
             Fix For: 1.0 (pre-incubation)


The DROP SCHEMA CASCADE command is not dropping any SPJs and libraries. 

>>drop schema t4qa cascade;
--- SQL operation complete.

>>get schemas;
Schemas in Catalog TRAFODION
============================
T4QA
_MD_
--- SQL operation complete.

>>set schema t4qa;
--- SQL operation complete.

>>get tables;
--- SQL operation complete.

>>get views;
--- SQL operation complete.

>>get procedures;
Procedures in Schema TRAFODION.T4QA
===================================
CALLABLESTATEMENTSAMPLE
RS349
--- SQL operation complete.

>>get libraries;
Libraries in Schema TRAFODION.T4QA
==================================
QASPJ
SPJRS
--- SQL operation complete.



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