Bug #29513 Dropping non-existent Falcon tablespace causes no error

• Submitted: 3 Jul 2007 13:28
• Modified: 11 Jul 2007 21:48
• Reporter: Robin Schumacher
• Status: Can't repeat
• Category: MySQL Server: Falcon storage engine
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any

[3 Jul 2007 13:28] Robin Schumacher

Description:
Dropping a Falcon tablespace that does not exist produces no error. 

How to repeat:
mysql> drop tablespace junior engine=falcon;  <---- TS does not exist
Query OK, 0 rows affected (0.00 sec)

[3 Jul 2007 14:06] MySQL Verification Team

Thank you for the bug report. I was unable to repeat with latest source
server (Windows and Linux):

c:\dev\6.0>bin\mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 6.0.1-alpha-nt Source distribution

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

mysql> drop tablespace junior engine=falcon;
ERROR 65433 (HY000): Unknown error -103

c:\dev\6.0>bin\mysqld-nt --standalone --console
070703 10:58:58  InnoDB: Started; log sequence number 0 46409
070703 10:58:59 [Note] Event Scheduler: Loaded 0 events
070703 10:58:59 [Note] bin\mysqld-nt: ready for connections.
Version: '6.0.1-alpha-nt'  socket: ''  port: 3306  Source distribution
Recovering database c:\dev\6.0\data\falcon_master.fts ...
first recovery block is 1
last recovery block is 167
recovery read block is 166
Recovery complete
Exception: table space "JUNIOR" is not defined
Transactions: 1 committed, 0 rolled back, 1 active, 0 post-commit
Activity on c:\dev\6.0\data\falcon_master.fts: 842 fetches, 49 reads, 1 writes
Activity on c:\dev\6.0\data\falcon_temporary.fts: 0 fetches, 1 reads, 1 writes
Activity on c:\dev\6.0\data\falcon_user.fts: 0 fetches, 1 reads, 1 writes