Re: [sqlite] Hierarchical Queries with Looping in SQLite DB

2017-07-06 Thread Jean-Luc Hainaut
On 06/07/2017 08:08, Ashif Ahamed wrote: When there is some data bringing looping scenario : *INSERT INTO FOLDER VALUES(2, 'Loop Data', 5);* After inserting this loop data , when i trigger the above recursive query in SQLite it keeps on running without bringing any results. Note: In oracle

Re: [sqlite] Hierarchical Queries with Looping in SQLite DB

2017-07-06 Thread Clemens Ladisch
Ashif Ahamed wrote: > I 'm trying to achieve , oracle's hierarchical CONNECT BY NOCYCLE PRIOR in > SQLite database hierarchical queries i.e. with clause queries(common table > expression) > > When there is a loop in the data ,with clause queries in SQLite database is > running for long with infinit

[sqlite] Hierarchical Queries with Looping in SQLite DB

2017-07-06 Thread Ashif Ahamed
I 'm trying to achieve , oracle's hierarchical CONNECT BY NOCYCLE PRIOR in SQLite database hierarchical queries i.e. with clause queries(common table expression) When there is a loop in the data ,with clause queries in SQLite database is running for long with infinite loops Consider the below sam