Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
any
-
None
-
None
Description
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.
>>