Bug #31303 Drop tablespace should support IF EXISTS
Submitted: 30 Sep 2007 13:53 Modified: 30 Sep 2007 19:04
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S4 (Feature request)
Version:6.0.2 OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[30 Sep 2007 13:53] Peter Laursen 
Description:
When MySQL 5.0 was released DROP TRIGGER did not support IF EXISTS.
That caused lots of turmoil (it was one of the most popular 'feature requests' here).  With hindsight I think everybody agree that was a mistake from the beginning

Now it seems that the mistake is repeating itself with DROP TABLESPACE

BTW: How do I query what TABLESPACES are there allready?
"SHOW TABLESPACES" is not supported, and I cannot find details in Information_Schema eiter

How to repeat:
use test;
create tablespace tsp3 add datafile 'istest3' engine = falcon;
drop tablespace if exists tsp3 engine= falcon;

/*
Error Code : 1064
You have an error in your SQL syntax; blablabla */
[30 Sep 2007 18:35] MySQL Verification Team 
create tablespace should support 'IF NOT EXISTS' as well.
[30 Sep 2007 19:04] Valeriy Kravchuk 
Thank you for a bug report. Verified just as described.
[14 Apr 2009 13:30] Valeriy Kravchuk 
Bug #44260 was marked as a duplicate of this one.