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: Dario Vanin
Date: December 05, 2019 06:12PM

I actually found a solution by myself: Type the following code from phpmyadmin. 5000 is my limit, so it can be changed. It seems not to support '0'

SET GLOBAL cte_max_recursion_depth = 5000

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.