title: Spring data jpa limit result with specification
body: <p>I have some trouble with Spring data JPA (with hibernate).
  I'm using it with a code like this one :</p>
  
  <pre><code>Pageable limit = new PageRequest(0, 200);
  Specification mySpecification = Specification.where(...);
  Page&lt;MyEntite&gt; listEntite = myRepository.findAll(mySpecification, limit);
  </code></pre>
  
  <p>My results are limited to 200 but when i'm looking at the generated query, the limitation is not on the generated SQL.</p>
  
  <p>I need to have the limitation on the generated SQL query to avoid memory errors.</p>
  
  <p>It looks like, the query retrieve all the datas and the filtering is done by spring-data</p>