@Test
  public void testCheckExpectedLocksSharedWrite() throws Exception {
    testCheckExpectedLocks(true);
  }
Collection of queries where we ensure that we get the locks that are expected.
ql/src/test/org/apache/hadoop/hive/ql/lockmgr/TestDbTxnManager2.java