Re: [Firebird-devel] CTE problem

2012-12-04 Thread Frank
On 12/01/2012 02:49 PM, Vlad Khorsun wrote: > I think, this is a bug. I added it to the tracker. kind regards Frank -- "Fascinating creatures, phoenixes, they can carry immensely heavy loads, their tears have healing powers and they make highly faithful pets." - J.K. Rowling --

Re: [Firebird-devel] CTE problem

2012-12-03 Thread Frank Ingermann
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 someth

Re: [Firebird-devel] CTE problem

2012-12-01 Thread Vlad Khorsun
> Hi, > I asked this in the support list, but got no answer: > > > I do not understand why > > set planonly; > with recursive > CTE_CNT1 as (select 0 as I >from RDB$DATABASE >union all select I + 1 >from CTE_CNT1 >where I < 9), > > CTE_CNT2 as (select I, 0 as J >from CTE_C

Re: [Firebird-devel] CTE problem

2012-11-30 Thread Frank Schlottmann-Gödde
On 29.11.2012 11:08, Frank Ingermann wrote: > Hi Frank, > > Am 29.11.2012 07:51, schrieb Frank: >> On 11/20/2012 10:53 AM, Frank Schlottmann-Gödde wrote: >> >> No idea, anybody? >> > Isn't it so that a CTE Select can only have one recursive member? I don't think so, because the construct we have

Re: [Firebird-devel] CTE problem

2012-11-29 Thread Frank Ingermann
Hi Frank, Am 29.11.2012 07:51, schrieb Frank: > On 11/20/2012 10:53 AM, Frank Schlottmann-Gödde wrote: > > No idea, anybody? > Isn't it so that a CTE Select can only have one recursive member? (at least that's what i remember from Vlad's presentation back in Bergamo, but i can't find a proof for

Re: [Firebird-devel] CTE problem

2012-11-28 Thread Frank
On 11/20/2012 10:53 AM, Frank Schlottmann-Gödde wrote: > Hi, > I asked this in the support list, but got no answer: > > > I do not understand why > > set planonly; > with recursive > CTE_CNT1 as (select 0 as I > from RDB$DATABASE > union all select I + 1 > from CTE_CNT1 > where

Re: [Firebird-devel] CTE problem

2012-11-20 Thread Frank
On 11/20/2012 11:03 AM, Dmitry Yemanov wrote: > 20.11.2012 13:53, Frank Schlottmann-Gödde wrote: >> >> I asked this in the support list, but got no answer: > > First of all, what FB version are you talking about? > Sorry, 2.5.2.26510 and 3.0.0.30126 Frank -- "Fascinating creatures, phoenixes

Re: [Firebird-devel] CTE problem

2012-11-20 Thread Dmitry Yemanov
20.11.2012 13:53, Frank Schlottmann-Gödde wrote: > > I asked this in the support list, but got no answer: First of all, what FB version are you talking about? Dmitry -- Monitor your physical, virtual and cloud infrastr

[Firebird-devel] CTE problem

2012-11-20 Thread Frank Schlottmann-Gödde
Hi, I asked this in the support list, but got no answer: I do not understand why set planonly; with recursive CTE_CNT1 as (select 0 as I from RDB$DATABASE union all select I + 1 from CTE_CNT1 where I < 9), CTE_CNT2 as (select I, 0 as J from CTE_CNT1 union all select