MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Recursive query aborted after 1001 iterations. Try increasing @@cte_max_recursion_depth to a larger value.
Posted by: Sudheesh KS
Date: December 30, 2019 08:06AM

To increase the max recusrion depth :

SET GLOBAL cte_max_recursion_depth=10000;

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Recursive query aborted after 1001 iterations. Try increasing @@cte_max_recursion_depth to a larger value.
Dario Vanin
December 05, 2019 05:41PM
Re: Recursive query aborted after 1001 iterations. Try increasing @@cte_max_recursion_depth to a larger value.
Dario Vanin
December 05, 2019 06:12PM
Re: Recursive query aborted after 1001 iterations. Try increasing @@cte_max_recursion_depth to a larger value.
Sudheesh KS
December 30, 2019 08:06AM


Sorry, you can't reply to this topic. It has been closed.

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.