Recursive query aborted after 1001 iterations. Try increasing @@cte_max_recursion_depth to a larger value.

[Dario Vanin]

Hi guys,

I created a simple view with a recursive query like:

WITH recursive upcoming_dates AS ( select user_id ....

The issue I have is that when the number of recursions goes beyond 1000, I get the following error:

#3636 - Recursive query aborted after 1001 iterations. Try increasing @@cte_max_recursion_depth to a larger value.

I cannot create a store procedure, as this view is part of a much larger process and I cannot reengineer the entire software. I also cannot find how to change my.conf to change this limit.

Anyone has experienced this before? Any help is highly appreciated.

Thanks,
Dario