[jira] [Created] (TRAFODION-3208) Drop Volatile Schema needs IF EXISTS syntax addition

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

Sandhya Sundaresan created TRAFODION-3208:
---------------------------------------------

             Summary: Drop Volatile Schema needs IF EXISTS syntax addition
                 Key: TRAFODION-3208
                 URL: https://issues.apache.org/jira/browse/TRAFODION-3208
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
    Affects Versions: any
            Reporter: Sandhya Sundaresan


We  need to extend parser and add ‘if exists’ clause to the ‘drop volatile schema’ stmt.

  DROP IMPLICIT VOLATILE SCHEMA *if exists* TABLES CLEANUP CASCADE;

And add it to the call in dropVolatileSchema method.

It will then succeed if schema doesn’t exist.

 

To reproduce : 

In this example, a new sqlci session returns an error even though no volatile tables were

created.

 

EsgynDB Advanced Conversational Interface 2.5.0

Copyright (c) 2015-2018 Esgyn Corporation

>>set parserflags 131072;

 

--- SQL operation complete.

>> 

>>DROP IMPLICIT VOLATILE SCHEMA TABLES CLEANUP CASCADE;

 

*** ERROR[1003] Schema TRAFODION.VOLATILE_SCHEMA_MXID110000306352124036339555720010000000002 does not exist.

 

--- SQL operation failed with errors.

>> 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)