MySQL Forums
Forum List  »  Views

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;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Recursive query aborted after 1001 iterations. Try increasing @@cte_max_recursion_depth to a larger value.
288
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.