HHH-8756 relaxed validation on non select queries when lock mode is set to NONE
HHH-8756 test cases for non select queries when lock mode is set to NONE
HHH-8756 cleanup
HHH-8821 corrected failing test