Jiri Cincura wrote:

>
> is there any way how to limit recursion when using CTE. Something like
> select * from MyCTE
> OPTION (MAXRECURSION 3)

AFAIK, nope. It was considered for the post-2.1 versions by Vlad and it
even exists in the tracker:

http://tracker.firebirdsql.org/browse/CORE-1290

but nobody has gone onto the implementation level yet.


Dmitry