MySQL Forums
Forum List  »  Views

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Recursive query aborted after 1001 iterations. Try increasing @@cte_max_recursion_depth to a larger value.
809
December 05, 2019 06:12PM


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.