Hi Adriano, Am 04.12.2011 19:36, schrieb Adriano dos Santos Fernandes: > On 30-11-2011 23:36, Adriano dos Santos Fernandes wrote: >> On 16-11-2011 22:39, Frank Ingermann wrote: >>> Hi all, >>> >>> i'm trying to combine the new Window functions in Fb3 with >>> recursive CTEs to get a _defined_ ordering of the recursive >>> child records in the result set. >>> >> >> The "recursive" problem is fixed, in fact it was a problem of window >> functions with empty streams. >> >> But it's still producing wrong value which I'll verify later. >> > > Fixed. Please test it.
Great!! I just did some quick and simple tests with today's snapshot build, these work perfectly! I will have to do some more "advanced" tests though, i will report back what i'll find. Thanks a lot! -- Mit freundlichen Grüßen, With kind regards, Frank Ingermann Klar Partner AG ***************************************** Phone +49 (24 08) 9509-0 Fax +49 (24 08) 9509-29 e-mail frank.ingerm...@klar-partner.de Klar Partner AG Promenade 3-9, 3. Etage 52076 Aachen, Germany http://www.klar-partner.de ***************************************** Klar Partner AG * Vorsitzende des Aufsichtsrats: Dr. rer. Pol. Belinda Lelke Dipl.-Inform.M.O.R. Aufsichtsrat: Dipl.Kauffr. Sybylla Vondenbusch, Carla Ruhnau-Klar Vorstandsvorsitz: Dipl.-Ing Dieter Klar * Vorstand: Dr. Gerhard Staudacher Sitz der Gesellschaft: Aachen * Registergericht: HRB 8630 Aachen Steuer-Nr DE225/5761/1121 * UST-Ident-Nr. DE220975397 ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel