Bug #13804 function works fine under 5.0.12 beta, but does not with 5.0.13
Submitted: 6 Oct 2005 14:00 Modified: 6 Oct 2005 14:35
Reporter: Bert De Haes Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S1 (Critical)
Version:mysql-5.0.13-rc-win32 OS:Windows (Windws XP SP 2)
Assigned to: MySQL Verification Team CPU Architecture:Any

[6 Oct 2005 14:00] Bert De Haes
Description:
I created a function with create function fn_streetkey. This works fine under MySQL server 5.0.12.
After upgrading to 5.0.13, this functions does not work anymore. I did serveral tests ( downgrading to 5.0.12 : it works, reinstall all, ... ) and foud that the variable Lword and Lword2 bahave strange. If, at some point in the function, return Lword, the value is correct. If I return trim(Lword), the value is empty. If in the function I do set Lword = trim(Lword), the value is empty ...

How to repeat:
I can sent scripts to generate my test database, to populate it and to test the function. I used this script to see the difference between 5.0.12 beta and 5.0.13.
[6 Oct 2005 14:35] MySQL Verification Team
Already reported and actually was introduced with 5.0.13:

http://bugs.mysql.com/bug.php?id=13725
http://bugs.mysql.com/bug.php?id=13613

Thank you for the bug report.