Re: [h2] Loop in Hierarchical Queries / Common Table Expressions in H2 Database

​Thanks Key for the response. I 'm trying to achieve , oracle's hierarchical CONNECT BY NOCYCLE PRIOR in h2 databse hierarchical queries i.e. with clause queries / common table expression, When there is a loop in the data ,with clause queries in h2 database is running for long and brings the out

Re: [h2] Loop in Hierarchical Queries / Common Table Expressions in H2 Database

I can't help in any way, but suggest you post plain text rather than screen shots -- it's a lot easy to copy/paste the faulty SQL ;-) On 4 July 2017 at 21:45, Ashif Ahamed wrote: > > > > Can anyone help on solving this scenario in H2 recursive queries.. > > > > >

[h2] Re: MVStore.compactMoveChunks() problem

Hi Andrei, Thanks for the patch and your email! Unfortunately, we have replaced MVStore in our project as we could not handle the database file size growth problem even using compactMoveChunks() method. Have nice days! Roland On Sunday, June 25, 2017 at 8:25:06 PM UTC+2, Andrei Tokar wrote: