MySQL Bugs: #33212: DROP TABLESPACE does not fail on non-existing Falcon tablespace

Bug #33212	DROP TABLESPACE does not fail on non-existing Falcon tablespace
Submitted:	13 Dec 2007 13:35	Modified:	16 Mar 2008 11:20
Reporter:	Philip Stoev	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Falcon storage engine	Severity:	S3 (Non-critical)
Version:	6.0.4	OS:	Any
Assigned to:	Sergey Vojtovich	CPU Architecture:	Any
Tags:	Falcon tablespace

Description:
DROP TABLESPACE with ENGINE = Falcon silently succeeds even if the tablespace does not exist or was dropped already.

How to repeat:
mysql> drop tablespace nosuchspace engine = 'Falcon';
Query OK, 0 rows affected (0.00 sec)

contrast with:

mysql> drop tablespace nosuchspace engine = 'NDBCLUSTER';
ERROR 1529 (HY000): Failed to drop TABLESPACE

Suggested fix:
Output a suitable error message.

Sergey, Please look at this when you get a chance.  It is another Falcon Tablespace issue.  I think that users should be able to redirect the location of temporary tables just like regular tables.

Thank you for the bug report. Verified on main and team tree:

[miguel@amanhecer 6.0f]$ bin/mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 6.0.5-alpha-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> drop tablespace nosuchspace engine = 'Falcon';
Query OK, 0 rows affected (0.47 sec)

mysql>

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/41102

ChangeSet@1.2778, 2008-01-22 21:00:29+04:00, svoj@mysql.com +8 -0
  BUG#33212 - DROP TABLESPACE does not fail on non-existing Falcon
              tablespace
  
  Dropping non-existing Falcon tablespace silently succeeds, whereas
  it should return error.

Pushed into 6.0.4-alpha

A note has been added to the 6.0.4 changelog: 

Dropping a tablespace for the Falcon storage engine when the specified tablespace does not exist would silently succeed, instead of generating a suitable error message.