Bug #31301 DROPPING non-existing TABLESPACE returns no error

• Submitted: 30 Sep 2007 12:29
• Modified: 30 Sep 2007 19:20
• Reporter: Peter Laursen (Basic Quality Contributor)
• Status: Duplicate
• Category: MySQL Server: Falcon storage engine
• Severity: S3 (Non-critical)
• Version: 6.0.2
• OS: Windows (Vista 32 bit)
• CPU Architecture: Any
• Tags: qc

[30 Sep 2007 12:29] Peter Laursen

Description:
DROPPING non-existing TABLESPACE returns no error

How to repeat:
SELECT VERSION();
/* returns 6.0.2-alpha-community-nt-debug*/

CREATE TABLESPACE neverused ADD DATAFILE 'newfile' ENGINE = Falcon;

drop tablespace neverused engine = falcon;
/*
(0 row(s)affected)
(0 ms taken)
*/

drop tablespace neverused engine = falcon;
/*
(0 row(s)affected)
(0 ms taken)
*

[30 Sep 2007 13:25] Peter Laursen

it rather looks like a side-effect/dublicate of this

http://bugs.mysql.com/bug.php?id=31296

drop tablespace neverexisted engine = falcon;

returns:
Error Code : 65433
Unknown error -103

[30 Sep 2007 19:20] Valeriy Kravchuk

Indeed, this looks like a duplicate/side effect of Bug #31296.