Bug #6559 DROP DATABASE forgets to drop triggers

• Submitted: 10 Nov 2004 19:07
• Modified: 5 Apr 2005 1:58
• Reporter: Paul DuBois
• Status: Closed
• Category: Server
• Severity: S3 (Non-critical)
• Version: 5.0.x
• Assigned to: Dmitri Lenev

[10 Nov 2004 19:07] Paul DuBois

Description:
When you create a trigger, it creates a .TRG file
in the database directory.  But DROP DATABASE
doesn't know that it should drop the .TRG file,
and fails.

How to repeat:
use test;
create table t (i int);
create trigger mytrig before insert on t for each row set @a = 1;
drop database test;

Result:

ERROR 1010 (HY000): Error dropping database (can't rmdir './test/', errno: 17)

[3 Apr 2005 16:50] Dmitri Lenev

Fixed in 5.0.4

[5 Apr 2005 1:58] Paul DuBois

Noted in 5.0.4 changelog.