Derived query applies OffsetScrollPosition only if the query is limited

[sergey-morenets]

Hi

We have the following repository:

public interface ProductRepository extends 
		JpaRepository<Product, Integer>, JpaSpecificationExecutor<Product> {
	
	Window<Product> findBy(ScrollPosition position);

And there are 20 product records in the database. So when we execute this piece of code then nothing is returned as we request page #4 with page size of 5 elements:

		PageRequest pageRequest = PageRequest.of(4, 5);
		Page<Product> productPage = productRepository.findAll(pageRequest);
		int size = productPage.getContent().size();  // 0

And when we convert PageRequest into OffsetScrollPosition we expect that it would return 0 records as well (offset is correct and equal to 20):

		OffsetScrollPosition position = pageRequest.toScrollPosition();
		long offset = position.getOffset();  // 20
		Window<Product> window = productRepository.findBy(position);
		
		for(Product product: window) {
			System.out.println(product);
		}
		
		size = window.getContent().size();

But this code returns all the existing records (20).