Bug #44260 DROP TABLESPACE is inconsistent
Submitted: 14 Apr 2009 12:10 Modified: 14 Apr 2009 13:27
Reporter: Hakan Küçükyılmaz Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[14 Apr 2009 12:10] Hakan Küçükyılmaz
Description:
DROP TABLESPACE is inconsistent in regards to IF EXISTS

How to repeat:
[14:07] root@test>DROP TABLE IF EXISTS t1;
Query OK, 0 rows affected, 1 warning (0.00 sec)

[14:07] root@test>DROP TABLESPACE IF EXISTS ts1 Engine InnoDB;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS ts1 Engine InnoDB' at line 1

[14:07] root@test>DROP TABLESPACE IF EXISTS ts1 Engine Falcon;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS ts1 Engine Falcon' at line 1

Suggested fix:
Be consistent and support IF EXISTS for tablespaces, too.
[14 Apr 2009 13:27] Valeriy Kravchuk
Duplicate of bug #31303.