[TRAFODION-3208] Drop Volatile Schema needs IF EXISTS syntax addition

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: any
• Component/s: sql-exe
• Assignee: Unassigned
• Reporter: Sandhya Sundaresan
• Created: 14/Sep/18 18:10
• Updated: 14/Sep/18 18:10

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.

>>