Hey, I have been using `SELECT_FOR_UPDATE_MVCC=FALSE` in order to use `FOR UPDATE` in my queries.
In the latest update of H2 (1.4.199) I encountered a new type of error. *The error message* FOR UPDATE is not allowed in DISTINCT or grouped select; SQL statement: *The actual query* select coalesce(max(r.sequence) + 1, 1) from <table> r where r.id = ? for update [90145-199] Are there any known workarounds, or I'm I stuck with 1.4.197? Regards Nickals -- 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.
