title: Cannot use native queries with dynamic sorting and/or pagination even if I have specified the count query
body: <p><strong>@Query(
  value = "select * from paper_entry where owner is null or owner = ?1",
  countQuery = "select count(*) from paper_entry where owner is not null or owner = ?1",
  nativeQuery = true)</strong></p>
  
  <p><strong>Page findAll(Long userId, Pageable pageable);</strong></p>
  
  <p>I use mysql 5.7, spring-data-jpa 1.11.3.RELEASE. As you can see, I follow the document <a href="https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#jpa.query-methods.at-query" rel="noreferrer">https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#jpa.query-methods.at-query</a>. However I got this error.</p>
  
  <p>Caused by: org.springframework.data.jpa.repository.query.InvalidJpaQueryMethodException: Cannot use native queries with dynamic sorting and/or pagination in method public abstract org.springframework.data.domain.Page com.gbdata.entry.persistence.dao.PaperEntryRepository.findAll(java.lang.Long,org.springframework.data.domain.Pageable)
      at org.springframework.data.jpa.repository.query.NativeJpaQuery.(NativeJpaQuery.java:55) ~[spring-data-jpa-1.11.3.RELEASE.jar:na]
      at org.springframework.data.jpa.repository.query.JpaQueryFactory.fromMethodWithQueryString(JpaQueryFactory.java:72) ~[spring-data-jpa-1.11.3.RELEASE.jar:na]
      at ........</p>