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)