[sqlite] Worked in 3.8.9, but now "recursive aggregate queries not supported"

[Luuk]

On 12-09-15 22:12, Aurel Wisse wrote:
> @Luuk : I tried your query and I cancelled after 9 minutes when it wasn't
> finished.
>
yes, it was/IS bad...

i should stick to non-recursive queries

select
     s1.calc_date,
     (select min(s2.calc_date)
         from securities s2
         where s2.calc_date>s1.calc_date)
from securities s1
order by s1.calc_date;