If autocommit is off (default behavior), the ENDSELECT statement does not affect locking. All locks held before the ENDSELECT statement remain. If autocommit is on, the ENDSELECT statement ends the query and locks are dropped.