Bug #10100 Stored procedures recursivity problem
| Submitted: | 22 Apr 2005 17:20 | Modified: | 2 Dec 2005 20:08 |
|---|---|---|---|
| Reporter: | John Kowawsky | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Stored Routines | Severity: | S3 (Non-critical) |
| Version: | 5 | OS: | Windows (Windows XP) |
| Assigned to: | Oleksandr Byelkin | CPU Architecture: | Any |
[22 Apr 2005 17:34]
Jorge del Conde
Verified w/5.0.5: mysql> SELECT test.recursivity(5);// +---------------------+ | test.recursivity(5) | +---------------------+ | 5 | +---------------------+ 1 row in set, 1 warning (0.00 sec) mysql> SELECT test.recursivity(6);// ERROR 2027 (HY000): Malformed packet mysql>
[20 May 2005 17:28]
Hartmut Holzgraefe
duplicate of 8680
[18 Aug 2005 15:02]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/28461
[8 Sep 2005 14:50]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/29506
[17 Oct 2005 15:04]
Michael Widenius
Ok to push after minor changes noted in review email
[10 Nov 2005 10:16]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/32137
[18 Nov 2005 14:58]
Konstantin Osipov
Reviewed over email.
[20 Nov 2005 19:08]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/32442
[20 Nov 2005 21:15]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/32443
[22 Nov 2005 23:11]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/32562
[23 Nov 2005 4:51]
Oleksandr Byelkin
Thank you for bugreport! We fixed only procedures for functions and triggers recursion left prohibited. bugfix was pushed to 5.0.17 source tree repository.
[28 Nov 2005 10:25]
Konstantin Osipov
The fix implements support for recursion in stored procedures only.
[29 Nov 2005 11:17]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/32820
[2 Dec 2005 20:08]
Paul DuBois
Noted in 5.0.17 changelog. Also made a note in the restrictions chapter about recursion not being allowed for stored functions and triggers.
[5 Mar 2006 10:16]
Konstantin Osipov
Bug#14361 has been marked as a duplicate of this bug.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.045 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: MySQL 5's custom funcions does not accept recursivity nor it give any warnings. Then I try this, mySQL create the function without any error. But when I execute, the functions goes well until it tries the recursive comand. The output give the error: ERROR 2027 (HY000): Malformed packet and the connection to mySQL is lost. I didnt tried with stored procedure but i guess it have the same problem. How to repeat: Try this: delimiter // DROP FUNCTION IF EXISTS test.recursivity;// CREATE FUNCTION test.recursivity(prm INTEGER) RETURNS CHAR(50) BEGIN DECLARE result CHAR(50) DEFAULT prm+' its below 6, variable is working'; /*--- if prm > 10, the funcion will call itself with parameter 1 and all variables will turn null --*/ IF prm > 5 THEN SELECT test.recursivity(1); END IF; RETURN result; END;// SELECT test.recursivity(1);// SELECT test.recursivity(4);// SELECT test.recursivity(5);// SELECT test.recursivity(6);// Suggested fix: the least thing to do is to give an error then trying to create recursive function. But recursive function would be greatly apreciated if suported. :(