Hi Frank, Am 30.11.2012 17:42, schrieb Frank Schlottmann-Gödde: > On 29.11.2012 11:08, Frank Ingermann wrote: >> Isn't it so that a CTE Select can only have one recursive member? > I don't think so, because the construct we have problems with, already > contains two recursive CTE's, must be something else.
You're right - and i was (kind of) right, too :-) A _single CTE_ can only have one recursive member, but you have multiple CTEs - which _should_ work. So i'm with Vlad: looks like a bug... cheers, Frank ------------------------------------------------------------------------------ Keep yourself connected to Go Parallel: BUILD Helping you discover the best ways to construct your parallel projects. http://goparallel.sourceforge.net Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel