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:
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
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.