Change read behavior on the InMemoryTransaction to use offset and allow not equal buf size

Change read behavior on the InMemoryTransaction to use offset and allow not equal buf size #12427