Experienced on SQL Server, confirmed not happening on Oracle. I would discuss on the opportunity of throwing an UnsupportedOperationException if user tries to lock the result of a reduction projection (e.g. count, max). I am not sure on how locking works at the JDBC level but I doubt there is something to actually lock when you ask for a count.