Comments - WITH RECURSIVE limited to 1001 records?
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
If you set the global value, it does not change the current session value, only those of any subsequent sessions.
SET SESSION max_recursive_iterations = 100000
should work. If you want the change to persist, then you will need to set it in a config file, which is read upon start.It worked. Thank you so much :-)