Hi, > Is shared lock on a table is hold for the duration > of all selects in UNION?
Yes. > 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 :)? Yes, set the trace level to 3 and then filter (grep) the .trace.db file for " lock:". Example: 12-28 11:40:07 lock: 2 exclusive write lock requesting for TEST 12-28 11:40:07 lock: 2 exclusive write lock added for TEST See also: http://h2database.com/html/features.html#trace_options 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.
