Bug #18179 CREATE FUNCTION in query browser fails.

• Submitted: 13 Mar 2006 8:17
• Modified: 14 Mar 2006 7:50
• Reporter: Magnus Blåudd
• Status: Closed
• Category: MySQL Query Browser
• Severity: S2 (Serious)
• Version: 5.0.18
• OS: Windows (Windows)
• Assigned to: Magnus Blåudd
• CPU Architecture: Any

[13 Mar 2006 8:17] Magnus Blåudd

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 14: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 5: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 7:50] Magnus Blåudd

Closing this as iisue was solved by updating MySQL Server to 5.0.19