Hi, I'm using the latest version (1.4.200) in embedded memory mode and I've set the isolation level to SERIALIABLE.
I've opened a single connection to the database in my JVM and I added a bunch of rows to a table. Let us say there is a column Column1 which is just an integer value. When I do: SELECT max(Column1) FROM Table1 It does not return the up-to-date result, until I commit, even in the same connection which added the rows. When I use READ COMMITTED isolation level, however, I don't see this issue. The max value is accurate. Is there any caveat with how aggregate functions are computed in serializable isolation level? Thank you, Venkat. -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/8ae9d125-36b0-4a24-b722-39afe67a792an%40googlegroups.com.
