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)
