Hi, > Would I be right in thinking that Lucene/FTL index does not honour > MVCC session isolation?
Yes, the fulltext search is updated as soon as the changes occur (before they are committed). > Also that H2 does not support MVCC Snapshot isolation? The MVCC implementation of H2 doesn't completely match other MVCC implementations. H2 doesn't support snapshot isolation, but read committed instead. This has advantages (I think the implementation is simpler and faster) and disadvantages (it's not fully compatible with PostgreSQL and Oracle). Please note that snapshot isolation is also problematic for certain use cases. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
