Bug #10038 Server crash when use user defined function in locked table
Submitted: 20 Apr 2005 17:09 Modified: 20 May 2005 20:51
Reporter: Rudenko Ilya Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: User-defined functions ( UDF ) Severity:S1 (Critical)
Version:5.0.4 OS:Linux (Fedora Core 3)
Assigned to: CPU Architecture:Any

[20 Apr 2005 17:09] Rudenko Ilya 
Description:
When executing query to locked table with UDF mysql return warning:

Table 'proc' was not locked with LOCK TABLES

after this query server don't locate any of UDF and return:

FUNCTION nau.MONTH_GEN does not exist

functions became available only after mysql server restarts

How to repeat:
Try to create function and execute SELECT query with UDF to locked table

SELECT *, UDF(param...) FROM locked_table
[20 Apr 2005 19:35] MySQL Verification Team 
Could you please provide a complete test case and verify if isn't
the same as bug: http://bugs.mysql.com/bug.php?id=9566.

Thanks.
[20 Apr 2005 20:51] Rudenko Ilya 
Sorry but when I try to dedicate code for test I got error which I describe in bug #10036

About bug #9566 I think they have same problems as I
[20 May 2005 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".