Hi, I wonder how two queries containing UNION behave concerning table locks (MVCC is off). Basically I need to do two selects atomically (isolation level is the default, 'read committed') and have an idea to use UNION for that. Is shared lock on a table is hold for the duration of all selects in UNION?
BTW, is there easy way to see the locks behavior, by enabling some logging etc (so that I wouldn't ask such stupid questions anymore :)? Yours, --oleg -- 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.
