On 9/11/15, Aurel Wisse <aurel.wisse at gmail.com> wrote: > I used a recursive aggregate query in 3.8.9 and it worked very well. Just > upgraded to 3.11.1 and the query is broken. > > This seems to be directly related to > > Check-in [6d2999af]: Do not allow recursive CTEs that use aggregate queries > in the recursive part. > > It worked, and now it is disabled. Why ? >
If it worked for you before, that was luck. Aggregate queries in a recursive CTE have never worked for the general case. In fact, I didn't realize that there were any cases where it did actually work. Can you share with use an example of an aggregate query in a recursive CTE that gives a reasonable answer? -- D. Richard Hipp drh at sqlite.org