I can confirm that was it. Recreated the database with the snapshot version.
Importantly, the UPDATE operation now completes within 11s (200k rows), so it seems like the bug if fixed. Thanks a lot and I'm looking forward to the stable version. Is there already a timeline for its release? On Friday, 27 July 2018 15:04:28 UTC+1, Evgenij Ryazanov wrote: > > I found a way to reproduce it. 1.4.197 creates an unexpected index and > such database does not work in a snapshot version. > > Creation of a new database using only the snapshot version should help. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
