Bug #18149 mysql create function server crash
Submitted: 11 Mar 2006 9:07 Modified: 13 Mar 2006 9:28
Reporter: Parul Vipparthi Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.1.8 OS:Windows (Win xp sp2)
Assigned to: MySQL Verification Team CPU Architecture:Any

[11 Mar 2006 9:07] Parul Vipparthi 
Description:
This simple function below crashes mysql server

DELIMITER $$

DROP FUNCTION IF EXISTS `mis`.`func111` $$
CREATE FUNCTION `mis`.`func111` () RETURNS INT
BEGIN
  return 12;
END $$

DELIMITER ;

How to repeat:
1. Open Query Browser
2. create a database called "mis"
3. right click on the "mis" database and create a function with name "func111"
4. return a value in the function
5. Click on execute button

thats it it crashes server with the following message
" mysql error could not fetch catalog schemata data, my sql server has gone away"

This also tries to open some VB Bug editor and when i try to cancel that it shuts down query browser

Please suggest a solution because SPs are working fine so as a workaround we've create SPs instead of functions

Thanks in advance
[13 Mar 2006 2:04] MySQL Verification Team 
Thank you for the bug report. I was unable to repeat with latest released
server 5.0.19, could you please test with that version.
Thanks in advance.
[13 Mar 2006 9:28] Parul Vipparthi 
Thank you... it works in 5.0.19 version.

parul
[12 May 2006 20:52] MySQL Verification Team 
The provided testcase would have crashed 5.0.18 if server was started with --skip-grant-tables. (bug #17595 is fixed now)