Bug #18179 CREATE FUNCTION in query browser fails.
Submitted: 13 Mar 2006 9:17 Modified: 14 Mar 2006 8:50
Reporter: Magnus Blaudd
Status: Closed
Category:MySQL Query Browser Severity:S2 (Serious)
Version:5.0.18 OS:Microsoft Windows (Windows)
Assigned to: Magnus Blaudd Target Version:

[13 Mar 2006 9:17] Magnus Blaudd 
Description:
Reported by Parul as part of bug#11835 but it's not the same problem.
>>
This function causes server crash version 5.0.18
used Query Browser to create this function

DELIMITER $$

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

DELIMITER ;

It gave an error like "mysql error could not fetch catalog schemata data, my sql
server has gone away"
It also tried to open a vb bug editor.
I would appreciate a solution which is a work around and need not re install the
server.
<<

How to repeat:
See above
[13 Mar 2006 15:17] Valeriy Kravchuk 
Thank you for a problem report. Please, specify the exact version of Query Browser used
and try to repeat with a newer version of MySQL servr, 5.0.19.
[14 Mar 2006 6:45] Parul Vipparthi 
I was using query browser 1.1.2 with mysql version 5.0.18 installed in c:\mysql5018 in win
xp sp2 

Now i have installed mysql 5.0.19 and function creation works with same query browser.

Thanks but 5.0.18 needs a fix

best regds
parul
[14 Mar 2006 8:50] Magnus Blaudd 
Closing this as iisue was solved by updating MySQL Server to 5.0.19