MySQL Bugs: #20497: Trigger with INSERT DELAYED causes Error 1165

Bug #20497	Trigger with INSERT DELAYED causes Error 1165
Submitted:	16 Jun 2006 12:11	Modified:	23 Aug 2006 19:11
Reporter:	Thomas Schwanhaeuser
Status:	Duplicate
Category:	Server	Severity:	S2 (Serious)
Version:	5.0.22	OS:	Linux (Linux AMD64)
Assigned to:	Bugs System	Target Version:

View
Add Comment
Files
Developer
Edit Submission
View Progress Log

Description:
A trigger which uses a INSERT DELAYED causes a Error 1165 claiming that the target table
is locked although it's not

How to repeat:
Create two tables a and b with identical schemas and create a trigger which inserts any
updates on table a in table b. It works fine with an INSERT command, but INSERT DELAYED
creates the error message:

Error: 1165 SQLSTATE: HY000 (ER_DELAYED_INSERT_TABLE_LOCKED)

Message: INSERT DELAYED can't be used with table '%s' because it is locked with LOCK
TABLES

An explicit UNLOCK TABLES before the command didn't show any effect.

This bug is a duplicate of bug#21483.

This bug reveals a part of a problem that will be fixed with a patch for bug#21483.