Bug #44260 DROP TABLESPACE is inconsistent

• Submitted: 14 Apr 2009 12:10
• Modified: 14 Apr 2009 13:27
• Reporter: Hakan Küçükyılmaz
• Status: Duplicate
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• OS: Any
• 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.