#1153 Empty body and parameters when editing a stored function

[Anonymous]

Originally created by: falkor.d...@gmail.com

What exact steps will reproduce the problem?
1. Create a function for test:
--Begin of query
DELIMITER $$
CREATE FUNCTION hello(teste INT) RETURNS INT
BEGIN
  RETURN teste;
END$$

SELECT hello(10) as teste$$
--End of query

Return of query:
+---------+
| teste   |
+---------+
| 10      |
+---------+

2. click on database, press F5 to show my new function
3. right click on function, click on "Edit stored runtime"
4. Open a blank screen only filds with information is:

- Name: hello
- Type: Funciont (returns a result)
- Returns int(11)
- data Access: Contains SQL
- Sql Security: definer

All anothers filds has no information

What was the expected output?
Parâmeters and my function code

What happened instead?
Dosen`t work,

Suggested fix (optional)?
sorry, i don`t no!

Version used?
HeidiSQL revision: 4.0 [r2405]
MySQL Server version: 5.0.67-community (work`s fine with
5.1.33-community-log running in Windows)
Operating system: (run Mysql is a redhat-linux-gnu) (run Heidi is windows
XP Sp3)

[Anonymous]

Originally posted by: a...@anse.de

Sorry I cannot reproduce that here neither with a 5.0.45 nor a 5.1.22 server.
Everything works here as expected.

Could you please post the result of these queries here so we can check them for problems:

1. SELECT ROUTINE_DEFINITION FROM information_schema.ROUTINES WHERE ROUTINE_NAME='hello';

2. SHOW CREATE FUNCTION hello;

Summary: Empty body and parameters when editing a stored function
Labels: Severity-Broken
Status: NeedInfo