MySQL used to support CONNECT BY PRIOR in its previous version(s). But due to some of the buggy code they have found in recursion and its associated modules, they have turned off this in the new versions.
The work arounds for this problem can be found at this place.
http://forums.mysql.com/read.php?10,32818,32818#msg-32818
http://jan.kneschke.de/projects/mysql/sp/
A very good theoritical explanation for the same can be found at
http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=697912
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment