HHH-8756 test cases for non select queries when lock mode is set to NONE